The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/sql-alterdefaultprivileges.html Description:
The syntax/synopsis of the "ALTER DEFAULT PRIVILEGES" statement on the https://www.postgresql.org/docs/13/sql-alterdefaultprivileges.html page can be simplified to the below form: ------------------------------------------------------------------------------------------ ALTER DEFAULT PRIVILEGES [ FOR { ROLE | USER } target_role [, ...] ] [ IN SCHEMA schema_name [, ...] ] abbreviated_grant_or_revoke where abbreviated_grant_or_revoke is one of: GRANT privileges TO { [ GROUP ] role_name | PUBLIC } [, ...] [ WITH GRANT OPTION ] REVOKE [ GRANT OPTION FOR ] privileges FROM { [ GROUP ] role_name | PUBLIC } [, ...] [ CASCADE | RESTRICT ] and privileges is one of: { { SELECT | INSERT | UPDATE | DELETE | TRUNCATE | REFERENCES | TRIGGER } [, ...] | ALL [ PRIVILEGES ] } ON TABLES { { USAGE | SELECT | UPDATE } [, ...] | ALL [ PRIVILEGES ] } ON SEQUENCES { EXECUTE | ALL [ PRIVILEGES ] } ON { FUNCTIONS | ROUTINES } { USAGE | ALL [ PRIVILEGES ] } ON TYPES { USAGE | CREATE | ALL [ PRIVILEGES ] } ON SCHEMAS ------------------------------------------------------------ This form is easier to understand.
