Hi!
I think we can add FOR TABLES clause for create/refresh subscription, for example: CREATE SUBSCRIPTION my_sub
CONNECTION... PUBLICATION my_pub [WITH ...] [ FOR TABLES t1, t2 | ALL TABLES ]. ALL TABLES is avalibale only for
superuser.FOR TABLES t1, t2 is available to owner of tables and superuser.
07.11.2018, 00:52, "Stephen Frost" <sfrost@snowman.net>:
> Greetings,
>
> * Evgeniy Efimkin (efimkin@yandex-team.ru) wrote:
>> As a first step I suggest we allow CREATE SUBSCRIPTION for table owner only.
>
> That's a nice idea but seems like we would want to have a way to filter
> what tables a subscription follows then..? Just failing if the
> publication publishes tables that we don't have access to or are not the
> owner of seems like a poor solution..
>
> Thanks!
>
> Stephen
--------
Ефимкин Евгений