GRANT SELECT

GRANT SELECT in Amazon RedShift and PostgreSQL.

• https://www.postgresql.org/docs/current/sql-grant.html

Examples

PostgreSQL

• GRANT SELECT ON ALL TABLES IN SCHEMA your_schema TO your_user;
• GRANT SELECT ON ALL TABLES IN SCHEMA public TO your_user;

Amazon RedShift

• 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
• Amazon Redshift: has_table_privilege
• GRANT ALL PRIVILEGES ON
• GRANT EXECUTE ON ALL FUNCTIONS IN SCHEMA public TO user;
• community.postgresql.postgresql_privs

Errors

• ERROR: permission denied for schema public

Activities

• Amazon Redshift: grant read only privileges to user

See also

• SELECT, GRANT SELECT ON
• 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