Content-Length: 264538 | pFad | http://github.com/postgrespro/postgres_cluster/commit/0725bf3aac643b077b031139a61d2a9b298cc0fe

97 Doc: fix description of privileges needed for ALTER PUBLICATION. · postgrespro/postgres_cluster@0725bf3 · GitHub
Skip to content

Commit 0725bf3

Browse files
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 mentioned nowhere.
1 parent ee69833 commit 0725bf3

File tree

1 file changed

+2
-1
lines changed

1 file changed

+2
-1
lines changed

doc/src/sgml/ref/alter_publication.sgml

Lines changed: 2 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -62,11 +62,12 @@ ALTER PUBLICATION <replaceable class="parameter">name</replaceable> RENAME TO <r
6262

6363
<para>
6464
You must own the publication to use <command>ALTER PUBLICATION</command>.
65+
Adding a table to a publication additionally requires owning that table.
6566
To alter the owner, you must also be a direct or indirect member of the new
6667
owning role. The new owner must have <literal>CREATE</literal> privilege on
6768
the database. Also, the new owner of a <literal>FOR ALL TABLES</literal>
6869
publication must be a superuser. However, a superuser can change the
69-
ownership of a publication while circumventing these restrictions.
70+
ownership of a publication regardless of these restrictions.
7071
</para>
7172
</refsect1>
7273

0 commit comments

Comments
 (0)








ApplySandwichStrip

pFad - (p)hone/(F)rame/(a)nonymizer/(d)eclutterfier!      Saves Data!


--- a PPN by Garber Painting Akron. With Image Size Reduction included!

Fetched URL: http://github.com/postgrespro/postgres_cluster/commit/0725bf3aac643b077b031139a61d2a9b298cc0fe

Alternative Proxies:

Alternative Proxy

pFad Proxy

pFad v3 Proxy

pFad v4 Proxy