PostgreSQL predefined roles

• https://www.postgresql.org/docs/current/predefined-roles.html

GRANT pg_read_all_data TO xxx;

• Read only

See also

• PostgreSQL users, predefined roles: pg_read_all_data, pg_monitor, create role, .pgpass, PostgreSQL read only user
• GRANT ALL
• GRANT, \ddp, GRANT USAGE, GRANT ALL PRIVILEGES, GRANT SELECT, View GRANTs on Redshift, has_table_privilege, has_schema_privilege, HAS_DATABASE_PRIVILEGE, SCHEMA, Privileges, GRANT EXECUTE