Allow a Postgres user to bypass RLS for all tables?

Question

Is there a way to allow a user to bypass RLS for all tables is Postgres?

score 2 · Accepted Answer · answered Dec 02 '22 at 17:42

2

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.

answered Dec 02 '22 at 17:42

richyen

`BYPASSRLS` sounds like exactly what I want. Thank you! – spierce7 Dec 02 '22 at 18:23

1 Answers1