From 35eaab71d1f776ecec7fd66d060b7e04987b06af Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Mon, 25 Mar 2019 17:18:06 -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 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 name [, ...] [ CASCAD 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 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 old_role [, ...] 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.39.5