diff options
| author | Peter Eisentraut <peter_e@gmx.net> | 2017-03-15 13:52:07 -0400 |
|---|---|---|
| committer | Peter Eisentraut <peter_e@gmx.net> | 2017-03-15 13:52:07 -0400 |
| commit | e76db009f079ece9408e37336887bc6457cc1fc6 (patch) | |
| tree | 62ae3049ff0580838b288816a8815c7efe8c8345 /doc | |
| parent | b5dd50f2c0ad8edcc3145aabe18788d448bf940d (diff) | |
Add more documentation and tests for publications
Add/correct documentation and add some tests related to how access
control around adding tables to publications works.
Diffstat (limited to 'doc')
| -rw-r--r-- | doc/src/sgml/logical-replication.sgml | 6 | ||||
| -rw-r--r-- | doc/src/sgml/ref/create_publication.sgml | 6 |
2 files changed, 9 insertions, 3 deletions
diff --git a/doc/src/sgml/logical-replication.sgml b/doc/src/sgml/logical-replication.sgml index 7b351f2727c..a6c04e923da 100644 --- a/doc/src/sgml/logical-replication.sgml +++ b/doc/src/sgml/logical-replication.sgml @@ -308,6 +308,12 @@ </para> <para> + To add tables to a publication, the user must have ownership rights on the + table. To create a publication that publishes all tables automatically, + the user must be a superuser. + </para> + + <para> To create a subscription, the user must be a superuser. </para> diff --git a/doc/src/sgml/ref/create_publication.sgml b/doc/src/sgml/ref/create_publication.sgml index 995f2bcf3c1..b00a91ef8a6 100644 --- a/doc/src/sgml/ref/create_publication.sgml +++ b/doc/src/sgml/ref/create_publication.sgml @@ -143,9 +143,9 @@ CREATE PUBLICATION <replaceable class="parameter">name</replaceable> </para> <para> - To add a table to a publication, the invoking user must have - <command>SELECT</command> privilege on given table. The - <command>FOR ALL TABLES</command> clause requires superuser. + To add a table to a publication, the invoking user must have ownership + rights on the table. The <command>FOR ALL TABLES</command> clause requires + the invoking user to be a superuser. </para> <para> |