GRANT SELECT

Amazon RedShift and PostgreSQL

Amazon RedShift: https://docs.aws.amazon.com/redshift/latest/dg/r_GRANT-examples.html

GRANT SELECT ON ALL TABLES IN SCHEMA your_schema TO your_user;
GRANT SELECT ON ALL TABLES IN SCHEMA your_schema TO GROUP your_group;

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
• has_table_privilege

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