Re:Supabase Auth: SSO, Mobile, and Server-Side Support
by niklasd on Friday April 14, 2023 @04:02AM
(#35566773)
Great, thank you for the reply! The simulation a policy sounds exciting. Looking forward to the news.
Re:Supabase Auth: SSO, Mobile, and Server-Side Support
by kiwicopple on Friday April 14, 2023 @06:17AM
(#35567694)
follow up on the "security invoker" - we've filed a bug report here which you can follow: https://github.com/djrobstep/schemainspect/issues/86
for this Launch Week we focused on generating policies (more on that in tomorrows launch week). This is hard for a lot of our audience who aren't familiar with SQL.
In the next few months we'll work on simulating a policy - being able to choose a specific user and see what data would be returned for that user.
We also have `supabase test db`, in case you missed it. It wraps pgTAP and pgProve so that you can write database tests.
> recreated without 'WITH (security_invoker)' even though they had security_invoker turned on before
we use migra for diff'ing. Thanks for raising this - we'll file a bug report asap.