diff options
| author | Tom Lane | 2019-03-25 21:18:06 +0000 |
|---|---|---|
| committer | Tom Lane | 2019-03-25 21:18:06 +0000 |
| commit | 50973687f185066a54e691218b08c866cb76a12a (patch) | |
| tree | e84581e7139b2fbd99e28f16b37cefc9ac507724 /doc/src | |
| parent | 9264888225ac4dabf399f06775073e14c38a87f7 (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
Diffstat (limited to 'doc/src')
| -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 81694b88e53..f501e3e66c4 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> | CURRENT_USER <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 ccd038629bf..41a57c8f368 100644 --- a/doc/src/sgml/ref/reassign_owned.sgml +++ b/doc/src/sgml/ref/reassign_owned.sgml @@ -88,9 +88,11 @@ REASSIGN OWNED BY { <replaceable class="PARAMETER">old_role</replaceable> | CURR <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> |