diff options
Diffstat (limited to 'doc/src/sgml/ref/drop_owned.sgml')
-rw-r--r-- | doc/src/sgml/ref/drop_owned.sgml | 9 |
1 files changed, 7 insertions, 2 deletions
diff --git a/doc/src/sgml/ref/drop_owned.sgml b/doc/src/sgml/ref/drop_owned.sgml index 9dd4184916d..a7fce5f64d5 100644 --- a/doc/src/sgml/ref/drop_owned.sgml +++ b/doc/src/sgml/ref/drop_owned.sgml @@ -29,10 +29,11 @@ DROP OWNED BY <replaceable class="PARAMETER">name</replaceable> [, ...] [ CASCAD <title>Description</title> <para> - <command>DROP OWNED</command> drops all the objects in the current + <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 will also be revoked. + database and on shared objects (databases, tablespaces) will also be + revoked. </para> </refsect1> @@ -92,6 +93,10 @@ DROP OWNED BY <replaceable class="PARAMETER">name</replaceable> [, ...] [ CASCAD reassigns the ownership of all the database objects owned by one or more roles. </para> + + <para> + Databases and tablespaces owned by the role(s) will not be removed. + </para> </refsect1> <refsect1> |