Search code examples
postgresqlpostgresql-14

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?

Solution

  • 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.