Disable RLS policies #38801
Unanswered
sandymcfadden
asked this question in
Feature Requests
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
Recently when developing a project I spent a fair bit of time troubleshooting and RLS issue I was facing. I found myself really wanting to be able to disable a RLS policy so I didn't lose it, but still didn't have it active.
There didn't seem to be a good way to do that.
While I was thinking about ways to do that I took a stab at it. There is likely a better way to approach it but for something that should be temporary and debugging purposes I thought this might work.
My thought was to add a disable option to policies and when used it would technically delete the policy, but also save all the details about it in IndexedDB in the browser. Disabled policies still show with active policies, but clearly marked as disabled, and you can enable them again in which case it would technically create a new policy using the saved details and then remove it from IndexedDB.
There are still some rough edges, but I took a quick pass at building this out here but didn't want to open a PR until there was a discussion.
master...sandymcfadden:supabase:add/disable-rls-policies
Would this be of interest to anyone else?
All reactions