diff options
| author | Peter Eisentraut <peter_e@gmx.net> | 2017-02-13 08:57:45 -0500 |
|---|---|---|
| committer | Peter Eisentraut <peter_e@gmx.net> | 2017-03-22 11:19:30 -0400 |
| commit | 4cfc9484d4effb0a3aa2c8742bdef0c2bc7a3ca5 (patch) | |
| tree | abc5444ab89b758b14cf86d3db21d79f0b7852af /doc/src/sgml/ref | |
| parent | 96a7128b7b4c9ce4fb51df8c8b216dfab6340766 (diff) | |
Refine rules for altering publication owner
Previously, the new owner had to be a superuser. The new rules are more
refined similar to other objects.
Reviewed-by: Petr Jelinek <petr.jelinek@2ndquadrant.com>
Diffstat (limited to 'doc/src/sgml/ref')
| -rw-r--r-- | doc/src/sgml/ref/alter_publication.sgml | 7 |
1 files changed, 5 insertions, 2 deletions
diff --git a/doc/src/sgml/ref/alter_publication.sgml b/doc/src/sgml/ref/alter_publication.sgml index 47d83b80be5..776661bbeb3 100644 --- a/doc/src/sgml/ref/alter_publication.sgml +++ b/doc/src/sgml/ref/alter_publication.sgml @@ -48,8 +48,11 @@ ALTER PUBLICATION <replaceable class="PARAMETER">name</replaceable> DROP TABLE < </para> <para> - To alter the owner, you must also be a direct or indirect member of the - new owning role. The new owner has to be a superuser + 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. </para> <para> |