aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2021-01-12 12:52:14 -0500
committerTom Lane <tgl@sss.pgh.pa.us>2021-01-12 12:52:24 -0500
commit0725bf3aac643b077b031139a61d2a9b298cc0fe (patch)
treeab6a77b06a2d501fd79959fc6f651873a2f8fb8c
parentee69833e6e5667b5396c4b843ef88a688a27bd1f (diff)
downloadpostgresql-0725bf3aac643b077b031139a61d2a9b298cc0fe.tar.gz
postgresql-0725bf3aac643b077b031139a61d2a9b298cc0fe.zip
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.
-rw-r--r--doc/src/sgml/ref/alter_publication.sgml3
1 files changed, 2 insertions, 1 deletions
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>