Difference between revisions of "GRANT USAGE"
Jump to navigation
Jump to search
↑ https://stackoverflow.com/a/10353730
Line 22: | Line 22: | ||
* <code>[[CREATE SCHEMA]]</code> | * <code>[[CREATE SCHEMA]]</code> | ||
* <code>[[grant assumerole]]</code> | * <code>[[grant assumerole]]</code> | ||
+ | [[GRANT ALL PRIVILEGES ON DATABASE]] | ||
== Activities == | == Activities == |
Revision as of 14:48, 15 December 2022
https://www.postgresql.org/docs/14/sql-grant.html
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 SELECT
GRANT ALL
CREATE SCHEMA
grant assumerole
GRANT ALL PRIVILEGES ON DATABASE
Activities
See also
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: