On 11/8/22 16:24, David G. Johnston wrote:
On Tue, Nov 8, 2022, 17:16 Bryn Llewellyn <bryn@xxxxxxxxxxxx
<mailto:bryn@xxxxxxxxxxxx>> 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@xxxxxxxxxxxxx
https://www.postgresql.org/message-id/CAKFQuwayij=AQRQxJhFuJ3Qejq3E-PfiBjJ9CoHx_L_46BEgXQ@xxxxxxxxxxxxxx
https://www.postgresql.org/message-id/CAKFQuwZVq-LerGMTN0E3_7MqhJwtuJuzf0GSnKG32mH_Qf24Zw@xxxxxxxxxxxxxx
David J.
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
