pg_read_all_data
pg_read_all_data allows reading all data (tables, views, sequences), as if having SELECT rights on those objects and USAGE rights on all schemas. This role does not bypass row-level security (RLS) policies. If RLS is being used, an administrator may wish to set BYPASSRLS on roles which this role is granted to.
Reading PG 18·Select a recorded version
- Name
- pg_read_all_data
- Manual terminology
- Predefined roles
Definition PG 18
pg_read_all_data allows reading all data (tables, views, sequences), as if having SELECT rights on those objects and USAGE rights on all schemas. This role does not bypass row-level security (RLS) policies. If RLS is being used, an administrator may wish to set BYPASSRLS on roles which this role is granted to.
Compare versions
Source references
Full definition and evidence JSON
Definition sources
center · PostgreSQL 18 · b7ebd726e6017f55081b4034b96d6a3289ae7937a26adaf72e58b9a08e009c75
Text language: en · b7ebd726e6017f55081b4034b96d6a3289ae7937a26adaf72e58b9a08e009c75