Difference between revisions of "Amazon Redshift: GRANT"
Jump to navigation
Jump to search
| (8 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
* https://docs.aws.amazon.com/redshift/latest/dg/r_GRANT.html | * https://docs.aws.amazon.com/redshift/latest/dg/r_GRANT.html | ||
| − | [[GRANT USAGE]] | + | [[GRANT USAGE ON]] { DATABASE shared_database_name [, ...] | SCHEMA shared_schema} |
TO { username | GROUP group_name | PUBLIC } [, ...] | TO { username | GROUP group_name | PUBLIC } [, ...] | ||
| + | [[GRANT ALL PRIVILEGES]] | ||
== Schema level permissions == | == Schema level permissions == | ||
* USAGE: Allows users to access objects in the schema. User still needs specific table-level permissions for each table within the schema | * 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 | * CREATE: Allows users to create objects within a schema using CREATE statement | ||
| + | |||
| + | * [[Amazon Redshift: show permissions]] | ||
== See also == | == See also == | ||
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
Schema level permissions[edit]
- 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
See also[edit]
Advertising:
