Difference between revisions of "Amazon Redshift: grant read only privileges to user"
Jump to navigation
Jump to search
m (Welcome moved page Amazon Redshift: grant read only provileges to user to Amazon Redshift: grant read only privileges to user) |
|||
| Line 31: | Line 31: | ||
== Related == | == Related == | ||
* <code>[[ALTER DEFAULT PRIVILEGES]]</code> | * <code>[[ALTER DEFAULT PRIVILEGES]]</code> | ||
| + | * <code>[[psql]]</code> | ||
== See also == | == See also == | ||
Revision as of 08:17, 12 May 2022
Contents
For users
0) List schemas and priviles:
1) Grant permssions 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
0) List schemas and priviles:
1) Grant permssions 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
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
Advertising:
