diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2021-01-12 12:52:14 -0500 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2021-01-12 12:52:14 -0500 |
| commit | cc865c0f319fde22540625e02863f42e9853b3e4 (patch) | |
| tree | 40baff5f42622ab7855357cb15996678627ab11c /doc/src | |
| parent | a3e51a36b77ab073df88860cc21b2a6094d699d4 (diff) | |
| download | postgresql-cc865c0f319fde22540625e02863f42e9853b3e4.tar.gz postgresql-cc865c0f319fde22540625e02863f42e9853b3e4.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.
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/ref/alter_publication.sgml | 3 |
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 c2946dfe0f8..faa114b2c68 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> |