Difference between revisions of "GRANT ALL"
Jump to navigation
Jump to search
| (3 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| − | + | [[GRANT]] { { CREATE | USAGE } [,...] | ALL [ PRIVILEGES ] } | |
| − | |||
| − | GRANT { { CREATE | USAGE } [,...] | ALL [ PRIVILEGES ] } | ||
ON SCHEMA schema_name [, ...] | ON SCHEMA schema_name [, ...] | ||
TO { username [ WITH GRANT OPTION ] | ROLE role_name | GROUP group_name | PUBLIC } [, ...] | TO { username [ WITH GRANT OPTION ] | ROLE role_name | GROUP group_name | PUBLIC } [, ...] | ||
Examples: | Examples: | ||
| − | <code>GRANT ALL PRIVILEGES ON SCHEMA your_schema TO your_username</code> | + | <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 ROLE your_rolename</code> | ||
<code>GRANT ALL PRIVILEGES ON SCHEMA your_schema TO GROUP your_group</code> | <code>GRANT ALL PRIVILEGES ON SCHEMA your_schema TO GROUP your_group</code> | ||
* [[GRANT ALL PRIVILEGES]] | * [[GRANT ALL PRIVILEGES]] | ||
| + | * [[GRANT USAGE, SELECT, UPDATE ON]] | ||
| Line 16: | Line 15: | ||
== See also == | == See also == | ||
| + | * {{GRANT ALL}} | ||
* {{GRANT}} | * {{GRANT}} | ||
[[Category:PostgreSQL]] | [[Category:PostgreSQL]] | ||
Latest revision as of 14:51, 20 September 2024
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_usernameGRANT ALL PRIVILEGES ON SCHEMA your_schema TO ROLE your_rolenameGRANT ALL PRIVILEGES ON SCHEMA your_schema TO GROUP your_group
See also[edit]
Advertising:
