Re: Additional info for CREATE ROLE with REPLICATION

2025-11-26 Thread Marcos Pegoraro
Em ter., 25 de nov. de 2025 às 23:22, Chao Li escreveu: > > <0001-Master - Additional info for create role with REPLICATION.diff> > ok, I understand that, but the REPLICATION paragraph says "A role having the REPLICATION attribute is a very highly privileged role". So the user thinks, well, if t

Re: Additional info for CREATE ROLE with REPLICATION

2025-11-25 Thread Chao Li
> On Nov 26, 2025, at 05:45, Marcos Pegoraro wrote: > > When a logical replication is created and a ROLE with REPLICATION clause is > used for that, there is no info on [0] that that role needs to have read > permission on those tables. CREATE PUBLICATION and CREATE SUBSCRIPTION > commands

Additional info for CREATE ROLE with REPLICATION

2025-11-25 Thread Marcos Pegoraro
When a logical replication is created and a ROLE with REPLICATION clause is used for that, there is no info on [0] that that role needs to have read permission on those tables. CREATE PUBLICATION and CREATE SUBSCRIPTION commands works as expected but replication doesn't work, only a "access denied"