diff options
| author | Bruce Momjian <bruce@momjian.us> | 2023-11-03 09:51:53 -0400 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2023-11-03 09:51:53 -0400 |
| commit | a8510a7d96b9d0e7f1937801f9340bd02c539b7f (patch) | |
| tree | 3f858e79d98495bc860e8bc6c7b030e4c60a982b /doc/src | |
| parent | 39c959ef25bd9cdd966ee024ab14f8f4214bb276 (diff) | |
| download | postgresql-a8510a7d96b9d0e7f1937801f9340bd02c539b7f.tar.gz postgresql-a8510a7d96b9d0e7f1937801f9340bd02c539b7f.zip | |
doc: ALTER DEFAULT PRIVILEGES does not affect inherited roles
Reported-by: Jordi Gutiérrez Hermoso
Discussion: https://postgr.es/m/72652d72e1816bfc3c05d40f9e0e0373d07823c8.camel@octave.org
Co-authored-by: Laurenz Albe
Backpatch-through: 11
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/ref/alter_default_privileges.sgml | 6 |
1 files changed, 5 insertions, 1 deletions
diff --git a/doc/src/sgml/ref/alter_default_privileges.sgml b/doc/src/sgml/ref/alter_default_privileges.sgml index f1d54f5aa35..8a6006188d3 100644 --- a/doc/src/sgml/ref/alter_default_privileges.sgml +++ b/doc/src/sgml/ref/alter_default_privileges.sgml @@ -137,7 +137,11 @@ REVOKE [ GRANT OPTION FOR ] <listitem> <para> The name of an existing role of which the current role is a member. - If <literal>FOR ROLE</literal> is omitted, the current role is assumed. + Default access privileges are not inherited, so member roles + must use <command>SET ROLE</command> to access these privileges, + or <command>ALTER DEFAULT PRIVILEGES</command> must be run for + each member role. If <literal>FOR ROLE</literal> is omitted, + the current role is assumed. </para> </listitem> </varlistentry> |