PostgreSQL read only user

• CREATE ROLE my_readonly WITH LOGIN PASSWORD '123456';
• GRANT CONNECT on database YourDB to my_readonly;
• GRANT pg_read_all_data, pg_monitor TO my_readonly;

select * from your_table;
value
-------
(0 rows)

Related

• GRANT CONNECT
• PostgreSQL predefined roles

See also

• PostgreSQL users, predefined roles: pg_read_all_data, pg_monitor, create role, .pgpass, PostgreSQL read only user
• CREATE ROLE
• 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