On 11/8/22 16:24, David G. Johnston wrote:
On Tue, Nov 8, 2022, 17:16 Bryn Llewellyn <[email protected] <mailto:[email protected]>> 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/[email protected] 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 [email protected]
