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]]
-<pre>
-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'
-;
-</pre>
-Ref: https://chartio.com/learn/amazon-redshift/how-to-view-permissions-in-amazon-redshift/
 == See also ==