Difference between revisions of "ALTER DEFAULT PRIVILEGES"
Jump to navigation
Jump to search
| (2 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 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:
