Difference between revisions of "ALTER DEFAULT PRIVILEGES"
Jump to navigation
Jump to search
(Redirected page to ALTER) Tag: New redirect |
|||
(5 intermediate revisions by one other user not shown) | |||
Line 1: | Line 1: | ||
− | + | * https://www.postgresql.org/docs/current/sql-alterdefaultprivileges.html | |
+ | |||
+ | [[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 == | ||
+ | * {{Alter}} | ||
+ | |||
+ | [[Category:SQL]] |
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: