diff options
| author | Simon Riggs <simon@2ndQuadrant.com> | 2010-04-02 17:29:22 +0000 |
|---|---|---|
| committer | Simon Riggs <simon@2ndQuadrant.com> | 2010-04-02 17:29:22 +0000 |
| commit | 3e754a89ea328f766cff5c19d3880d63cc3330f8 (patch) | |
| tree | 47fee968669162e7d64ca9cd4ed48323123db7e0 /doc/src | |
| parent | 33065ef8bc52253ae855bc959576e52d8a28ba06 (diff) | |
| download | postgresql-3e754a89ea328f766cff5c19d3880d63cc3330f8.tar.gz postgresql-3e754a89ea328f766cff5c19d3880d63cc3330f8.zip | |
Clarify some behaviours of REASSIGN OWNED and DROP OWNED BY.
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/ref/drop_owned.sgml | 6 | ||||
| -rw-r--r-- | doc/src/sgml/ref/reassign_owned.sgml | 11 |
2 files changed, 14 insertions, 3 deletions
diff --git a/doc/src/sgml/ref/drop_owned.sgml b/doc/src/sgml/ref/drop_owned.sgml index 9dd4184916d..ced8876b0fc 100644 --- a/doc/src/sgml/ref/drop_owned.sgml +++ b/doc/src/sgml/ref/drop_owned.sgml @@ -1,5 +1,5 @@ <!-- -$PostgreSQL: pgsql/doc/src/sgml/ref/drop_owned.sgml,v 1.6 2008/11/14 10:22:46 petere Exp $ +$PostgreSQL: pgsql/doc/src/sgml/ref/drop_owned.sgml,v 1.7 2010/04/02 17:29:22 sriggs Exp $ PostgreSQL documentation --> @@ -92,6 +92,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 owned by the role(s) will not be removed. + </para> </refsect1> <refsect1> diff --git a/doc/src/sgml/ref/reassign_owned.sgml b/doc/src/sgml/ref/reassign_owned.sgml index df37f4a386b..f9636479cb5 100644 --- a/doc/src/sgml/ref/reassign_owned.sgml +++ b/doc/src/sgml/ref/reassign_owned.sgml @@ -1,5 +1,5 @@ <!-- -$PostgreSQL: pgsql/doc/src/sgml/ref/reassign_owned.sgml,v 1.4 2008/11/14 10:22:47 petere Exp $ +$PostgreSQL: pgsql/doc/src/sgml/ref/reassign_owned.sgml,v 1.5 2010/04/02 17:29:22 sriggs Exp $ PostgreSQL documentation --> @@ -74,9 +74,16 @@ REASSIGN OWNED BY <replaceable class="PARAMETER">old_role</replaceable> [, ...] </para> <para> + <command>REASSIGN OWNED</command> requires privileges on both the + source role(s) and the target role. + </para> + + <para> The <xref linkend="sql-drop-owned" endterm="sql-drop-owned-title"> command is an alternative that - drops all the database objects owned by one or more roles. + drops all the database objects owned by one or more roles. Note + also that <command>DROP OWNED</command> requires privileges only + on the source role(s). </para> <para> |