diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2019-03-25 17:18:05 -0400 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2019-03-25 17:18:05 -0400 |
| commit | b3bd819632701d53580d9433f3f80c529865f86d (patch) | |
| tree | 01bd6692d6e4612c485671e55aa42f41165346b9 | |
| parent | 8edd0e79460b414b1d971895312e549e95e12e4f (diff) | |
| download | postgresql-b3bd819632701d53580d9433f3f80c529865f86d.tar.gz postgresql-b3bd819632701d53580d9433f3f80c529865f86d.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 4c66da2b340..09107bef647 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 0fffd6088a9..42f72a726fd 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</replaceable> 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> |