postgres.git / summary / log / commit / refs

commit    a2768e44e879e62d9bb6f0bda4d695cd73d03843
Author:   Tom Lane <tgl@sss.pgh.pa.us>
Date:     Tue Jan 12 17:52:14 2021 +0000
First released in: 14.0, 10.16, 11.11, 12.6, 13.2

    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 mentioned
    nowhere.


doc/src/sgml/ref/alter_publication.sgml | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/doc/src/sgml/ref/alter_publication.sgml b/doc/src/sgml/ref/alter_publication.sgml index 534e598d93e..de998445d0a 100644 --- a/doc/src/sgml/ref/alter_publication.sgml +++ b/doc/src/sgml/ref/alter_publication.sgml @@ -62,11 +62,12 @@ ALTER PUBLICATION <replaceable class="parameter">name</replaceable> RENAME TO <r <para> You must own the publication to use <command>ALTER PUBLICATION</command>. + Adding a table to a publication additionally requires owning that table. To alter the owner, you must also be a direct or indirect member of the new owning role. The new owner must have <literal>CREATE</literal> privilege on the database. Also, the new owner of a <literal>FOR ALL TABLES</literal> publication must be a superuser. However, a superuser can change the - ownership of a publication while circumventing these restrictions. + ownership of a publication regardless of these restrictions. </para> </refsect1> [parent: ddf0be8ca47c]