Commit272db03

committed

doc: ALTER DEFAULT PRIVILEGES does not affect inherited roles

Reported-by: Jordi Gutiérrez HermosoDiscussion:https://postgr.es/m/72652d72e1816bfc3c05d40f9e0e0373d07823c8.camel@octave.orgCo-authored-by: Laurenz AlbeBackpatch-through: 11

1 parent6e1cca5 commit272db03Copy full SHA for 272db03

File tree

-1

lines changed

-1

lines changed

Lines changed: 5 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -137,7 +137,11 @@ REVOKE [ GRANT OPTION FOR ]`
`137`	`137`	`<listitem>`
`138`	`138`	`<para>`
`139`	`139`	`The name of an existing role of which the current role is a member.`
`140`		`- If <literal>FOR ROLE</literal> is omitted, the current role is assumed.`
	`140`	`+ Default access privileges are not inherited, so member roles`
	`141`	`+ must use <command>SET ROLE</command> to access these privileges,`
	`142`	`+ or <command>ALTER DEFAULT PRIVILEGES</command> must be run for`
	`143`	`+ each member role. If <literal>FOR ROLE</literal> is omitted,`
	`144`	`+ the current role is assumed.`
`141`	`145`	`</para>`
`142`	`146`	`</listitem>`
`143`	`147`	`</varlistentry>`

Comments

(0)