Difference between revisions of "GRANT ALL"
Jump to navigation
Jump to search
(Created page with " * GRANT ALL PRIVILEGES {{GRANT}}") |
|||
(4 intermediate revisions by one other user not shown) | |||
Line 1: | Line 1: | ||
+ | |||
+ | GRANT { { CREATE | USAGE } [,...] | ALL [ PRIVILEGES ] } | ||
+ | ON SCHEMA schema_name [, ...] | ||
+ | TO { username [ WITH GRANT OPTION ] | ROLE role_name | GROUP group_name | PUBLIC } [, ...] | ||
+ | Examples: | ||
+ | <code>GRANT ALL PRIVILEGES ON SCHEMA your_schema TO your_username</code> | ||
+ | <code>GRANT ALL PRIVILEGES ON SCHEMA your_schema TO ROLE your_rolename</code> | ||
+ | <code>GRANT ALL PRIVILEGES ON SCHEMA your_schema TO GROUP your_group</code> | ||
* [[GRANT ALL PRIVILEGES]] | * [[GRANT ALL PRIVILEGES]] | ||
− | {{GRANT}} | + | * <code>[[\dn+]]</code> |
+ | * <code>[[GRANT USAGE]]</code> | ||
+ | |||
+ | == See also == | ||
+ | * {{GRANT}} | ||
+ | |||
+ | [[Category:PostgreSQL]] |
Latest revision as of 15:19, 18 November 2022
GRANT { { CREATE | USAGE } [,...] | ALL [ PRIVILEGES ] } ON SCHEMA schema_name [, ...] TO { username [ WITH GRANT OPTION ] | ROLE role_name | GROUP group_name | PUBLIC } [, ...]
Examples:
GRANT ALL PRIVILEGES ON SCHEMA your_schema TO your_username
GRANT ALL PRIVILEGES ON SCHEMA your_schema TO ROLE your_rolename
GRANT ALL PRIVILEGES ON SCHEMA your_schema TO GROUP your_group
See also[edit]
Advertising: