Postgres Pro
Downloads
Home   >   mailing lists

Re: "set role" semantics - Mailing list pgsql-general

From Adrian Klaver
Subject Re: "set role" semantics
Date
Msg-id 535c0f36-099f-6f0b-924a-b32856d2312a@aklaver.com
Whole thread Raw
In response to Re: "set role" semantics  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: "set role" semantics  (Bryn Llewellyn <bryn@yugabyte.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: "set role" semantics
Next
From: David Gauthier
Date:
Subject: escaping double-quotes in varchar array