| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, Bryn Llewellyn <bryn(at)yugabyte(dot)com> |
| Cc: | pgsql-general list <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: "set role" semantics |
| Date: | 2022-11-09 01:02:31 |
| Message-ID: | 535c0f36-099f-6f0b-924a-b32856d2312a@aklaver.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 11/8/22 16:24, David G. Johnston wrote:
> On Tue, Nov 8, 2022, 17:16 Bryn Llewellyn <bryn(at)yugabyte(dot)com
> <mailto:bryn(at)yugabyte(dot)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
>
> David J.
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Gauthier | 2022-11-09 01:27:35 | escaping double-quotes in varchar array |
| Previous Message | David G. Johnston | 2022-11-09 00:24:11 | Re: "set role" semantics |