Difference between revisions of "GRANT USAGE"
Jump to navigation
Jump to search
↑ https://stackoverflow.com/a/10353730
| (33 intermediate revisions by 4 users not shown) | |||
| Line 1: | Line 1: | ||
| − | * [[GRANT]] | + | https://www.postgresql.org/docs/14/sql-grant.html |
| + | * <code>[[GRANT]]</code> USAGE | ||
* [[Amazon Redshift: GRANT]] | * [[Amazon Redshift: GRANT]] | ||
| + | == 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 usage on foreign data wrapper]] [[postgres_fdw]] to <USERNAME>; | ||
| + | |||
| + | == Related == | ||
| + | * [[PostgreSQL: Database roles]] | ||
| + | * <code>[[GRANT]] your_defined_role TO your_username;</code> | ||
| + | * <code>[[GRANT SELECT]]</code> | ||
| + | * <code>[[GRANT CONNECT]]</code> | ||
| + | * [[GRANT USAGE, SELECT, UPDATE ON]] | ||
| + | * <code>[[GRANT ALL]]</code> | ||
| + | * <code>[[CREATE SCHEMA]]</code> | ||
| + | * <code>[[grant assumerole]]</code> | ||
| + | * <code>[[GRANT ALL PRIVILEGES ON DATABASE]]</code> | ||
| + | |||
| + | == Activities == | ||
| + | * [[Amazon Redshift: grant read only privileges to user]] | ||
== See also == | == See also == | ||
| + | * {{GRANT USAGE}} | ||
* {{GRANT}} | * {{GRANT}} | ||
[[Category:Databases]] | [[Category:Databases]] | ||
Latest revision as of 08:15, 23 July 2024
https://www.postgresql.org/docs/14/sql-grant.html
GRANTUSAGE- Amazon Redshift: GRANT
Contents
Examples[edit]
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
grant usage on foreign data wrapper postgres_fdw to <USERNAME>;
Related[edit]
- PostgreSQL: Database roles
GRANT your_defined_role TO your_username;GRANT SELECTGRANT CONNECT- GRANT USAGE, SELECT, UPDATE ON
GRANT ALLCREATE SCHEMAgrant assumeroleGRANT ALL PRIVILEGES ON DATABASE
Activities[edit]
See also[edit]
- 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:
