8000 doc: ALTER DEFAULT PRIVILEGES does not affect inherited roles · postgres/postgres@272db03 · GitHub
[go: up one dir, main page]
Skip to content

Commit 272db03

Browse files
bmomjianbmomjian
committed
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
1 parent 6e1cca5 commit 272db03

File tree

1 file changed

+5
-1
lines changed

1 file changed

+5
-1
lines changed

‎doc/src/sgml/ref/alter_default_privileges.sgml

Lines changed: 5 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -137,7 +137,11 @@ REVOKE [ GRANT OPTION FOR ]
137137
<listitem>
138138
<para>
139139
The name of an existing role of which the current role is a member.
140-
If <literal>FOR ROLE</literal> is omitted, the current role is assumed.
140+
Default access privileges are not inherited, so member roles
141+
must use <command>SET ROLE</command> to access these privileges,
142+
or <command>ALTER DEFAULT PRIVILEGES</command> must be run for
143+
each member role. If <literal>FOR ROLE</literal> is omitted,
144+
the current role is assumed.
141145
</para>
142146
</listitem>
143147
</varlistentry>

0 commit comments

Comments
 (0)
0