On 11/8/22 16:24, David G. Johnston wrote:
On Tue, Nov 8, 2022, 17:16 Bryn Llewellyn <b...@yugabyte.com
<mailto:b...@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.1644613...@sss.pgh.pa.us
https://www.postgresql.org/message-id/CAKFQuwayij=aqrqxjhfuj3qejq3e-pfibjj9cohx_l_46be...@mail.gmail.com
https://www.postgresql.org/message-id/cakfquwzvq-lergmtn0e3_7mqhjwtujuzf0gsnkg32mh_qf2...@mail.gmail.com
David J.
--
Adrian Klaver
adrian.kla...@aklaver.com