diff options
Diffstat (limited to 'doc/src/sgml/ref/reassign_owned.sgml')
| -rw-r--r-- | doc/src/sgml/ref/reassign_owned.sgml | 23 |
1 files changed, 13 insertions, 10 deletions
diff --git a/doc/src/sgml/ref/reassign_owned.sgml b/doc/src/sgml/ref/reassign_owned.sgml index 57f2e59996c..584042f2cc3 100644 --- a/doc/src/sgml/ref/reassign_owned.sgml +++ b/doc/src/sgml/ref/reassign_owned.sgml @@ -30,8 +30,9 @@ REASSIGN OWNED BY <replaceable class="PARAMETER">old_role</replaceable> [, ...] <para> <command>REASSIGN OWNED</command> instructs the system to change - the ownership of the database objects owned by one of the - old_roles, to new_role. + the ownership of database objects owned by any of the + <replaceable class="PARAMETER">old_roles</replaceable> to + <replaceable class="PARAMETER">new_role</replaceable>. </para> </refsect1> @@ -80,16 +81,18 @@ REASSIGN OWNED BY <replaceable class="PARAMETER">old_role</replaceable> [, ...] <para> The <xref linkend="sql-drop-owned"> command is an alternative that - 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). + simply drops all the database objects owned by one or more roles. </para> <para> - The <command>REASSIGN OWNED</command> command does not affect the - privileges granted to the old_roles in objects that are not owned - by them. Use <command>DROP OWNED</command> to revoke those - privileges. + The <command>REASSIGN OWNED</command> command does not affect any + privileges granted to the <replaceable class="PARAMETER">old_roles</> for + objects that are not owned by them. Use <command>DROP OWNED</command> to + revoke such privileges. + </para> + + <para> + See <xref linkend="role-removal"> for more discussion. </para> <para> @@ -104,7 +107,7 @@ REASSIGN OWNED BY <replaceable class="PARAMETER">old_role</replaceable> [, ...] <title>Compatibility</title> <para> - The <command>REASSIGN OWNED</command> statement is a + The <command>REASSIGN OWNED</command> command is a <productname>PostgreSQL</productname> extension. </para> </refsect1> |