Commit3e754a8

committed

Clarify some behaviours of REASSIGN OWNED and DROP OWNED BY.

1 parent33065ef commit3e754a8Copy full SHA for 3e754a8

File tree

+14

-3

lines changed

+14

-3

lines changed

Lines changed: 5 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -1,5 +1,5 @@`
`1`	`1`	`<!--`
`2`		`-$PostgreSQL: pgsql/doc/src/sgml/ref/drop_owned.sgml,v 1.6 2008/11/14 10:22:46 petere Exp $`
	`2`	`+$PostgreSQL: pgsql/doc/src/sgml/ref/drop_owned.sgml,v 1.7 2010/04/02 17:29:22 sriggs Exp $`
`3`	`3`	`PostgreSQL documentation`
`4`	`4`	`-->`
`5`	`5`
`@@ -92,6 +92,10 @@ DROP OWNED BY <replaceable class="PARAMETER">name</replaceable> [, ...] [ CASCAD`
`92`	`92`	`reassigns the ownership of all the database objects owned by one or`
`93`	`93`	`more roles.`
`94`	`94`	`</para>`
	`95`	`+`
	`96`	`+ <para>`
	`97`	`+ Databases owned by the role(s) will not be removed.`
	`98`	`+ </para>`
`95`	`99`	`</refsect1>`
`96`	`100`
`97`	`101`	`<refsect1>`

Lines changed: 9 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -1,5 +1,5 @@`
`1`	`1`	`<!--`
`2`		`-$PostgreSQL: pgsql/doc/src/sgml/ref/reassign_owned.sgml,v 1.4 2008/11/14 10:22:47 petere Exp $`
	`2`	`+$PostgreSQL: pgsql/doc/src/sgml/ref/reassign_owned.sgml,v 1.5 2010/04/02 17:29:22 sriggs Exp $`
`3`	`3`	`PostgreSQL documentation`
`4`	`4`	`-->`
`5`	`5`
`@@ -73,10 +73,17 @@ REASSIGN OWNED BY <replaceable class="PARAMETER">old_role</replaceable> [, ...]`
`73`	`73`	`that contains objects owned by a role that is to be removed.`
`74`	`74`	`</para>`
`75`	`75`
	`76`	`+ <para>`
	`77`	`+ <command>REASSIGN OWNED</command> requires privileges on both the`
	`78`	`+ source role(s) and the target role.`
	`79`	`+ </para>`
	`80`	`+`
`76`	`81`	`<para>`
`77`	`82`	`The <xref linkend="sql-drop-owned"`
`78`	`83`	`endterm="sql-drop-owned-title"> command is an alternative that`
`79`		`- drops all the database objects owned by one or more roles.`
	`84`	`+ drops all the database objects owned by one or more roles. Note`
	`85`	`+ also that <command>DROP OWNED</command> requires privileges only`
	`86`	`+ on the source role(s).`
`80`	`87`	`</para>`
`81`	`88`
`82`	`89`	`<para>`

Comments

(0)