The synopsis of "ALTER DEFAULT PRIVILEGES" statement is too difficult to understand
От | PG Doc comments form |
---|---|
Тема | The synopsis of "ALTER DEFAULT PRIVILEGES" statement is too difficult to understand |
Дата | |
Msg-id | 161255874662.10297.16360845410596491854@wrigleys.postgresql.org обсуждение исходный текст |
Ответы |
Re: The synopsis of "ALTER DEFAULT PRIVILEGES" statement is too difficult to understand
|
Список | pgsql-docs |
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.
В списке pgsql-docs по дате отправления: