Re: "set role" semantics

On 11/8/22 16:24, David G. Johnston wrote:
> On Tue, Nov 8, 2022, 17:16 Bryn Llewellyn <bryn@yugabyte.com 
> <mailto:bryn@yugabyte.com>> wrote:
> 
> 
>     Notice that I didn't grant "connect" on either of the databases,
>     "d1" or "d2", to any of the roles, "clstr$mgr, "d1$mgr", or "d2$mgr".
> 
> 
> You didn't have to since PUBLIC gets that privilege and you didn't 
> revoke it.
> 
> https://www.postgresql.org/docs/current/ddl-priv.html 
> <https://www.postgresql.org/docs/current/ddl-priv.html>

Revoking PUBLIC has been explained before to you(Bryn Llewellyn).

A quick search:

https://www.postgresql.org/message-id/2176817.1644613186@sss.pgh.pa.us

https://www.postgresql.org/message-id/CAKFQuwayij=AQRQxJhFuJ3Qejq3E-PfiBjJ9CoHx_L_46BEgXQ@mail.gmail.com

https://www.postgresql.org/message-id/CAKFQuwZVq-LerGMTN0E3_7MqhJwtuJuzf0GSnKG32mH_Qf24Zw@mail.gmail.com

> 
> David J.

-- 
Adrian Klaver
adrian.klaver@aklaver.com