Home > mailing lists

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

From	David G. Johnston
Subject	Re: "set role" semantics
Date	November 9, 2022 03:24:11
Msg-id	CAKFQuwbGgeKJdagniw4bd69hBMoQwW9pm2UAkzE_95Me+CGovg@mail.gmail.com Whole thread Raw
In response to	"set role" semantics (Bryn Llewellyn <bryn@yugabyte.com>)
Responses	Re: "set role" semantics (Adrian Klaver <adrian.klaver@aklaver.com>)
List	pgsql-general

On Tue, Nov 8, 2022, 17:16 Bryn Llewellyn <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.

David J.

From: Bryn Llewellyn
Date: 09 November 2022, 03:16:31
Subject: "set role" semantics

From: Adrian Klaver
Date: 09 November 2022, 04:02:31
Subject: Re: "set role" semantics