Difference between revisions of "GRANT ALL"
Jump to navigation
Jump to search
| Line 5: | Line 5: | ||
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> | ||
Revision as of 14:50, 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
Advertising:
