Amazon Redshift: grant read only privileges to user
(Redirected from Amazon Redshift: grant read only provileges 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 DATASHARE
GRANT 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: