Antonin Houska <ah@cybertec.at> wrote:
> Euler Taveira <euler@eulerto.com> wrote:
>
> > On Tue, May 10, 2022, at 5:37 AM, Antonin Houska wrote:
> >
> > My understanding is that the rows/columns filtering is a way for the
> > *publisher* to control which data is available to particular replica. From
> > this point of view, the publication privileges would just make the control
> > complete.
> >
> > I agree. IMO it is a new feature. We already require high privilege for logical
> > replication. Hence, we expect the replication user to have access to all data.
> > Unfortunately, nobody mentioned about this requirement during the row filter /
> > column list development; someone could have written a patch for GRANT ... ON
> > PUBLICATION.
>
> I can try that for PG 16, unless someone is already working on it.
The patch is attached to this message.
--
Antonin Houska
Web: https://www.cybertec-postgresql.com