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 } [, ...] | ||
| + | [[GRANT ALL PRIVILEGES]] | ||
== Schema level permissions == | == Schema level permissions == | ||
Revision as of 08:38, 7 December 2021
GRANT USAGE ON { DATABASE shared_database_name [, ...] | SCHEMA shared_schema} TO { username | GROUP group_name | PUBLIC } [, ...]
GRANT ALL PRIVILEGES
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:
