spierce7
Reputation: 15746
Allow a Postgres user to bypass RLS for all tables?
Is there a way to allow a user to bypass RLS for all tables is Postgres?
Upvotes: 1
Views: 5278
Answers (1)
richyen
Reputation: 9968
According to the documentation, it is possible for a user to be assigned the BYPASSRLS attribute by another superuser. With this, a user can bypass RLS for all tables in Postgres.
And of course, superusers can bypass RLS be default.
Upvotes: 2
Related Questions
- How can I insert records into Postgres with RLS when user has `grant all` perms and a loose policy
- PostgreSQL RLS explicit Policies
- PostgreSQL RLS policy to specific user is not working as expected and applies to all users
- Can't create RLS on postgresql
- Apply row level security on all tables in a PSQL database for a user
- RLS Policy doesn't applied for table in PostgreSQL while the RLS has been enabled
- Possible to restrict PostgreSQL security definer function to RLS use?
- postgres how to apply RLS only for one user
- PostgreSQL RLS is not applied as intended
- Skip RLS checks temporarily