Re: pgsql: Add new GUC createrole_self_grant. - Mailing list pgsql-hackers

From David G. Johnston
Subject Re: pgsql: Add new GUC createrole_self_grant.
Date
Msg-id CAKFQuwYr=ZrZJqgdH4hp=pSu_zp19qjDdC485KdJGz6PQZBd_w@mail.gmail.com
Whole thread Raw
In response to Re: pgsql: Add new GUC createrole_self_grant.  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-hackers
On Sat, Jan 14, 2023 at 6:12 PM David G. Johnston <david.g.johnston@gmail.com> wrote:
While the function owner has their own pg_db_role_setting preference for this setting,

Should we be pointing out that if the role with CREATEROLE isn't also a LOGIN role then there is little point to setting createrole_self_grant on it specifically?  Instead this setting should be set for any user that can SET to the CREATEROLE role but does have a LOGIN attribute.

David J.

pgsql-hackers by date:

Previous
From: Justin Pryzby
Date:
Subject: [PATCH] pg_restore: use strerror for errors other than ENOENT
Next
From: vignesh C
Date:
Subject: Re: fixing CREATEROLE