Difference between revisions of "ALTER DEFAULT PRIVILEGES"
Jump to navigation
Jump to search
| Line 2: | Line 2: | ||
[[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 [, ...] ] | ||
Revision as of 13:46, 24 November 2022
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON TABLES TO xxx;
ALTER DEFAULT PRIVILEGES
[ FOR { ROLE | USER } target_role [, ...] ]
[ IN SCHEMA schema_name [, ...] ]
See also
Advertising:
