diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2019-03-25 17:18:06 -0400 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2019-03-25 17:18:06 -0400 |
| commit | 35eaab71d1f776ecec7fd66d060b7e04987b06af (patch) | |
| tree | f71803c008333be1e5823a150dd79502d211fd7b | |
| parent | 99e414cacd063550d576cb9b1acac503157a3bce (diff) | |
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
| -rw-r--r-- | doc/src/sgml/ref/drop_owned.sgml | 2 | ||||
| -rw-r--r-- | doc/src/sgml/ref/reassign_owned.sgml | 8 |
2 files changed, 6 insertions, 4 deletions
diff --git a/doc/src/sgml/ref/drop_owned.sgml b/doc/src/sgml/ref/drop_owned.sgml index a3f223bfc0b..5b73a989318 100644 --- a/doc/src/sgml/ref/drop_owned.sgml +++ b/doc/src/sgml/ref/drop_owned.sgml @@ -32,7 +32,7 @@ DROP OWNED BY <replaceable class="PARAMETER">name</replaceable> [, ...] [ CASCAD <command>DROP OWNED</command> drops all the objects within the current database that are owned by one of the specified roles. Any privileges granted to the given roles on objects in the current - database and on shared objects (databases, tablespaces) will also be + database or on shared objects (databases, tablespaces) will also be revoked. </para> </refsect1> diff --git a/doc/src/sgml/ref/reassign_owned.sgml b/doc/src/sgml/ref/reassign_owned.sgml index 876ab5167d0..9e5916fe03c 100644 --- a/doc/src/sgml/ref/reassign_owned.sgml +++ b/doc/src/sgml/ref/reassign_owned.sgml @@ -87,9 +87,11 @@ REASSIGN OWNED BY <replaceable class="PARAMETER">old_role</replaceable> [, ...] <para> The <command>REASSIGN OWNED</command> command does not affect any - privileges granted to the <replaceable class="PARAMETER">old_roles</> for - objects that are not owned by them. Use <command>DROP OWNED</command> to - revoke such privileges. + privileges granted to + the <replaceable class="parameter">old_roles</replaceable> on objects + that are not owned by them. Likewise, it does not affect default + privileges created with <command>ALTER DEFAULT PRIVILEGES</command>. + Use <command>DROP OWNED</command> to revoke such privileges. </para> <para> |