Commitb3bd819

committed

Doc: clarify that REASSIGN OWNED doesn't handle default privileges.

It doesn't touch regular privileges either, but only the latter wasexplicitly stated.Discussion:https://postgr.es/m/155348282848.9808.12629518043813943231@wrigleys.postgresql.org

1 parent8edd0e7 commitb3bd819Copy full SHA for b3bd819

File tree

-4

lines changed

-4

lines changed

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -32,7 +32,7 @@ DROP OWNED BY { <replaceable class="parameter">name</replaceable> \| CURRENT_USER`
`32`	`32`	`<command>DROP OWNED</command> drops all the objects within the current`
`33`	`33`	`database that are owned by one of the specified roles. Any`
`34`	`34`	`privileges granted to the given roles on objects in the current`
`35`		`- databaseand on shared objects (databases, tablespaces) will also be`
	`35`	`+ databaseor on shared objects (databases, tablespaces) will also be`
`36`	`36`	`revoked.`
`37`	`37`	`</para>`
`38`	`38`	`</refsect1>`

Lines changed: 5 additions & 3 deletions

Original file line number	Diff line number	Diff line change
`@@ -88,9 +88,11 @@ REASSIGN OWNED BY { <replaceable class="parameter">old_role</replaceable> \| CURR`
`88`	`88`
`89`	`89`	`<para>`
`90`	`90`	`The <command>REASSIGN OWNED</command> command does not affect any`
`91`		`- privileges granted to the <replaceable class="parameter">old_roles</replaceable> for`
`92`		`- objects that are not owned by them. Use <command>DROP OWNED</command> to`
`93`		`- revoke such privileges.`
	`91`	`+ privileges granted to`
	`92`	`+ the <replaceable class="parameter">old_roles</replaceable> on objects`
	`93`	`+ that are not owned by them. Likewise, it does not affect default`
	`94`	`+ privileges created with <command>ALTER DEFAULT PRIVILEGES</command>.`
	`95`	`+ Use <command>DROP OWNED</command> to revoke such privileges.`
`94`	`96`	`</para>`
`95`	`97`
`96`	`98`	`<para>`

Comments

(0)