On 2020-May-07, Tom Lane wrote: > FWIW, I would argue that LOGIN permits logging in on a regular SQL > connection, while REPLICATION should permit logging in on a > replication connection, and there's no reason for either to depend on > or require the other.
I agree with this. > >> Also- what about per-database connections? Does having REPLICATION mean > >> you get to override the CONNECT privileges on a database, if you're > >> connecting for the purposes of doing logical replication? > > No, why would it? Should LOGIN privilege mean you can override > CONNECT? That's nonsense. You need the respective privilege > to connect with the protocol you want to connect with, and you > also need CONNECT on the DB you want to connect to. And this. -- Álvaro Herrera https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
