Difference between revisions of "ALTER DEFAULT PRIVILEGES"
Jump to navigation
Jump to search
(One intermediate revision by one other user not shown) | |||
Line 3: | Line 3: | ||
[[ALTER]] DEFAULT PRIVILEGES IN [[SCHEMA]] public [[GRANT SELECT ON TABLES]] TO xxx; | [[ALTER]] DEFAULT PRIVILEGES IN [[SCHEMA]] public [[GRANT SELECT ON TABLES]] TO xxx; | ||
+ | ALTER DEFAULT PRIVILEGES | ||
+ | [ FOR { ROLE | USER } target_role [, ...] ] | ||
+ | [ IN SCHEMA schema_name [, ...] ] | ||
+ | |||
+ | == Related == | ||
+ | * [[GRANT]] | ||
== See also == | == See also == |
Latest revision as of 15:39, 5 July 2023
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON TABLES TO xxx;
ALTER DEFAULT PRIVILEGES [ FOR { ROLE | USER } target_role [, ...] ] [ IN SCHEMA schema_name [, ...] ]
Related[edit]
See also[edit]
Advertising: