Skip to content

Commit 35eaab7

Browse files
committed
Doc: clarify that REASSIGN OWNED doesn't handle default privileges.
It doesn't touch regular privileges either, but only the latter was explicitly stated. Discussion: https://postgr.es/m/155348282848.9808.12629518043813943231@wrigleys.postgresql.org
1 parent 99e414c commit 35eaab7

File tree

2 files changed

+6
-4
lines changed

2 files changed

+6
-4
lines changed

doc/src/sgml/ref/drop_owned.sgml

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -32,7 +32,7 @@ DROP OWNED BY <replaceable class="PARAMETER">name</replaceable> [, ...] [ CASCAD
3232
<command>DROP OWNED</command> drops all the objects within the current
3333
database that are owned by one of the specified roles. Any
3434
privileges granted to the given roles on objects in the current
35-
database and on shared objects (databases, tablespaces) will also be
35+
database or on shared objects (databases, tablespaces) will also be
3636
revoked.
3737
</para>
3838
</refsect1>

doc/src/sgml/ref/reassign_owned.sgml

Lines changed: 5 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -87,9 +87,11 @@ REASSIGN OWNED BY <replaceable class="PARAMETER">old_role</replaceable> [, ...]
8787

8888
<para>
8989
The <command>REASSIGN OWNED</command> command does not affect any
90-
privileges granted to the <replaceable class="PARAMETER">old_roles</> for
91-
objects that are not owned by them. Use <command>DROP OWNED</command> to
92-
revoke such privileges.
90+
privileges granted to
91+
the <replaceable class="parameter">old_roles</replaceable> on objects
92+
that are not owned by them. Likewise, it does not affect default
93+
privileges created with <command>ALTER DEFAULT PRIVILEGES</command>.
94+
Use <command>DROP OWNED</command> to revoke such privileges.
9395
</para>
9496

9597
<para>

0 commit comments

Comments
 (0)