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 | 374fb6c0f9dad1048a2ef1ef814a27e01c8887d7 (patch) | |
| tree | e10bd69f366cb6ae332511be6cbf532fc2233681 | |
| parent | 171baf18325e30997123e9d5cf3e1a81e3a3f484 (diff) | |
| download | postgresql-374fb6c0f9dad1048a2ef1ef814a27e01c8887d7.tar.gz postgresql-374fb6c0f9dad1048a2ef1ef814a27e01c8887d7.zip | |
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 d03cc578450..fd48d2aff9f 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> |