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: 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
• Amazon Redshift: has_table_privilege
• GRANT ALL PRIVILEGES ON

GRANT EXECUTE ON ALL FUNCTIONS IN SCHEMA public TO user;

community.postgresql.postgresql_privs_module

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