Amazon Redshift: grant read only privileges to user

For users

0) List schemas and priviles:

\dn+

1) Grant permissions to schema:

GRANT USAGE ON SCHEMA your_schema TO your_user;

Output: GRANT

2) Grant permissions on tables in the schema:

GRANT SELECT ON ALL TABLES IN SCHEMA your_schema TO your_user;

Output: GRANT

3) Verify changes:

\dn+

For groups

0) List schemas and priviles:

\dn+

1) Grant permissions to schema:

GRANT USAGE ON SCHEMA your_schema TO GROUP your_group;

Output: GRANT

2) Grant permissions on tables in the schema:

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

Output: GRANT

3) Verify changes:

\dn+

Related

• ALTER DEFAULT PRIVILEGES
• Connect to a database: psql
• https://docs.aws.amazon.com/redshift/latest/dg/r_GRANT-examples.html
• GRANT USAGE ON DATASHARE
• GRANT USAGE, GRANT SELECT

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
• Amazon Redshift, aws redshift, Amazon Redshift query editor, GRANT, AQUA, has schema privilege, WLM, Amazon Redshift Spectrum, metrics, VACUUM, SET