Amazon Redshift: grant read only privileges to user
Jump to navigation
Jump to search
Contents
For users[edit]
0) List schemas and priviles:
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:
For groups[edit]
0) List schemas and priviles:
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:
Related[edit]
ALTER DEFAULT PRIVILEGES- Connect to a database:
psql - https://docs.aws.amazon.com/redshift/latest/dg/r_GRANT-examples.html
GRANT USAGE ON DATASHAREGRANT USAGE, GRANT SELECT
See also[edit]
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
Advertising:
