GRANT SELECT

GRANT SELECT ON ALL TABLES IN SCHEMA public TO xxx;

GRANT SELECT ON mytable TO xxx;

GRANT SELECT ON mytable TO xxx;

ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON TABLES TO xxx;

Related

• GRANT USAGE

See also

• 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

https://stackoverflow.com/questions/760210/how-do-you-create-a-read-only-user-in-postgresql