Difference between revisions of "Amazon Redshift: GRANT"
Jump to navigation
Jump to search
Line 4: | Line 4: | ||
TO { username | GROUP group_name | PUBLIC } [, ...] | TO { username | GROUP group_name | PUBLIC } [, ...] | ||
+ | |||
+ | == 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 | ||
+ | * CREATE: Allows users to create objects within a schema using CREATE statement | ||
== See also == | == See also == |
Revision as of 08:45, 12 November 2021
GRANT USAGE ON { DATABASE shared_database_name [, ...] | SCHEMA shared_schema} TO { username | GROUP group_name | PUBLIC } [, ...]
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
- CREATE: Allows users to create objects within a schema using CREATE statement
See also
Advertising: