Commit0725bf3

committed

Doc: fix description of privileges needed for ALTER PUBLICATION.

Adding a table to a publication requires ownership of the table(in addition to ownership of the publication). This was mentionednowhere.

1 parentee69833 commit0725bf3Copy full SHA for 0725bf3

File tree

-1

lines changed

-1

lines changed

Lines changed: 2 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -62,11 +62,12 @@ ALTER PUBLICATION <replaceable class="parameter">name</replaceable> RENAME TO <r`
`62`	`62`
`63`	`63`	`<para>`
`64`	`64`	`You must own the publication to use <command>ALTER PUBLICATION</command>.`
	`65`	`+ Adding a table to a publication additionally requires owning that table.`
`65`	`66`	`To alter the owner, you must also be a direct or indirect member of the new`
`66`	`67`	`owning role. The new owner must have <literal>CREATE</literal> privilege on`
`67`	`68`	`the database. Also, the new owner of a <literal>FOR ALL TABLES</literal>`
`68`	`69`	`publication must be a superuser. However, a superuser can change the`
`69`		`- ownership of a publicationwhile circumventing these restrictions.`
	`70`	`+ ownership of a publicationregardless of these restrictions.`
`70`	`71`	`</para>`
`71`	`72`	`</refsect1>`
`72`	`73`

Comments

(0)