From f7dc6ceaae3283b0861f0e6b5b66a6d5eca9c03e Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Mon, 25 Mar 2019 17:18:05 -0400 Subject: [PATCH] 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 --- doc/src/sgml/ref/drop_owned.sgml | 2 +- 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 81694b88e5..f501e3e66c 100644 --- a/doc/src/sgml/ref/drop_owned.sgml +++ b/doc/src/sgml/ref/drop_owned.sgml @@ -32,7 +32,7 @@ DROP OWNED BY { name | CURRENT_USER DROP OWNED 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. diff --git a/doc/src/sgml/ref/reassign_owned.sgml b/doc/src/sgml/ref/reassign_owned.sgml index ccd038629b..41a57c8f36 100644 --- a/doc/src/sgml/ref/reassign_owned.sgml +++ b/doc/src/sgml/ref/reassign_owned.sgml @@ -88,9 +88,11 @@ REASSIGN OWNED BY { old_role | CURR The REASSIGN OWNED command does not affect any - privileges granted to the old_roles for - objects that are not owned by them. Use DROP OWNED to - revoke such privileges. + privileges granted to + the old_roles on objects + that are not owned by them. Likewise, it does not affect default + privileges created with ALTER DEFAULT PRIVILEGES. + Use DROP OWNED to revoke such privileges. -- 2.40.0