Difference between revisions of "GRANT USAGE"
Jump to navigation
Jump to search
↑ https://stackoverflow.com/a/10353730
| Line 4: | Line 4: | ||
== Examples == | == Examples == | ||
| − | + | <code>GRANT USAGE ON [[ALL SEQUENCES]] IN [[SCHEMA]] your_schema TO your_role_group;</code><ref>https://stackoverflow.com/a/10353730</ref> | |
| − | + | <code>[[GRANT USAGE ON]] [[SCHEMA]] your_schema TO [[GROUP]] your_role_group;</code> | |
| − | + | [[GRANT USAGE ON SCHEMA]] your_schema TO your_role; | |
GRANT | GRANT | ||
| − | |||
| − | |||
| − | |||
== Related == | == Related == | ||
Revision as of 11:10, 16 December 2022
https://www.postgresql.org/docs/14/sql-grant.html
GRANTUSAGE- Amazon Redshift: GRANT
Contents
Examples
GRANT USAGE ON ALL SEQUENCES IN SCHEMA your_schema TO your_role_group;[1]
GRANT USAGE ON SCHEMA your_schema TO GROUP your_role_group;
GRANT USAGE ON SCHEMA your_schema TO your_role;
GRANT
Related
- PostgreSQL: Database roles
GRANT your_defined_role TO your_username;GRANT SELECTGRANT ALLCREATE SCHEMAgrant assumeroleGRANT ALL PRIVILEGES ON DATABASEGRANT CONNECT
Activities
See also
- GRANT USAGE
GRANT,\ddp,GRANT USAGE,GRANT ALL PRIVILEGES,GRANT SELECT, View GRANTs on Redshift,has_table_privilege,has_schema_privilege,HAS_DATABASE_PRIVILEGE,SCHEMA, Privileges,GRANT EXECUTE
Advertising:
