Difference between revisions of "GRANT USAGE"
Jump to navigation
Jump to search
↑ https://stackoverflow.com/a/10353730
| Line 18: | Line 18: | ||
* <code>[[GRANT]] your_defined_role TO your_username;</code> | * <code>[[GRANT]] your_defined_role TO your_username;</code> | ||
* <code>[[GRANT SELECT]]</code> | * <code>[[GRANT SELECT]]</code> | ||
| + | * <code>[[GRANT CONNECT]]</code> | ||
* <code>[[GRANT ALL]]</code> | * <code>[[GRANT ALL]]</code> | ||
* <code>[[CREATE SCHEMA]]</code> | * <code>[[CREATE SCHEMA]]</code> | ||
* <code>[[grant assumerole]]</code> | * <code>[[grant assumerole]]</code> | ||
* <code>[[GRANT ALL PRIVILEGES ON DATABASE]]</code> | * <code>[[GRANT ALL PRIVILEGES ON DATABASE]]</code> | ||
| − | |||
== Activities == | == Activities == | ||
Revision as of 08:04, 18 July 2024
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
grant usage on foreign data wrapper postgres_fdw to <USERNAME>;
Related
- PostgreSQL: Database roles
GRANT your_defined_role TO your_username;GRANT SELECTGRANT CONNECTGRANT ALLCREATE SCHEMAgrant assumeroleGRANT ALL PRIVILEGES ON DATABASE
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:
