Difference between revisions of "Amazon Redshift: GRANT"

Latest revision as of 13:14, 26 January 2022

GRANT USAGE ON { DATABASE shared_database_name [, ...] | SCHEMA shared_schema}
    TO { username | GROUP group_name | PUBLIC } [, ...]

GRANT ALL PRIVILEGES

USAGE: Allows users to access objects in the schema. User still needs specific table-level permissions for each table within the schema
CREATE: Allows users to create objects within a schema using CREATE statement

@@ Line 1: / Line 1: @@
 * https://docs.aws.amazon.com/redshift/latest/dg/r_GRANT.html
-  [[GRANT USAGE]] ON { DATABASE shared_database_name [, ...] | SCHEMA shared_schema}
+  [[GRANT USAGE ON]] { DATABASE shared_database_name [, ...] | SCHEMA shared_schema}
       TO { username | GROUP group_name | PUBLIC } [, ...]
+ [[GRANT ALL PRIVILEGES]]
 == Schema level permissions ==
@@ Line 9: / Line 10: @@
 * CREATE: Allows users to create objects within a schema using CREATE statement
-== Show permissions ==
+* [[Amazon Redshift: show permissions]]
- [[has_table_privilege]]
- SELECT
-     u.usename,
-     s.schemaname,
-     has_schema_privilege(u.usename,s.schemaname,'create') AS user_has_select_permission,
-     has_schema_privilege(u.usename,s.schemaname,'usage') AS user_has_usage_permission
- FROM
-     [[pg_user]] u
- CROSS JOIN
-     (SELECT DISTINCT schemaname FROM pg_tables) s
- WHERE
-     u.usename = 'myUserName'
-     AND s.schemaname = 'mySchemaName'
- ;
-Ref: https://chartio.com/learn/amazon-redshift/how-to-view-permissions-in-amazon-redshift/
 == See also ==