Difference between revisions of "GRANT USAGE"

Latest revision as of 08:15, 23 July 2024

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>;

@@ Line 1: / Line 1: @@
 https://www.postgresql.org/docs/14/sql-grant.html
+* <code>[[GRANT]]</code> USAGE
+* [[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
-* <code>[[GRANT]]</code>
-* [[Amazon Redshift: GRANT]]
+ [[grant usage on foreign data wrapper]] [[postgres_fdw]] to <USERNAME>;
- GRANT USAGE ON [[ALL SEQUENCES]] IN [[SCHEMA]] your_schema TO your_group;<ref>https://stackoverflow.com/a/10353730</ref>
+== 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>
- [[GRANT USAGE ON]] [[SCHEMA]] your_schema TO [[GROUP]] your_group;
+== Activities ==
+* [[Amazon Redshift: grant read only privileges to user]]
 == See also ==
+* {{GRANT USAGE}}
 * {{GRANT}}
 [[Category:Databases]]