GRANT pg read all data TO xxx;

GRANT pg_read_all_data TO xxx;

Related

• read-only
• GRANT SELECT ON ALL TABLES IN SCHEMA
• PostgreSQL predefined roles

See also

• ALTER, ALTER DATABASE, ALTER TABLE, ALTER DEFAULT PRIVILEGES, ALTER MATERIALIZED VIEW
• 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