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:
