Re: [PATCH v2] use has_privs_for_role for predefined roles
Joe Conway <mail@joeconway.com>
From: Joe Conway <mail@joeconway.com>
To: Nathan Bossart <nathandbossart@gmail.com>
Cc: Robert Haas <robertmhaas@gmail.com>,
Joshua Brindle <joshua.brindle@crunchydata.com>, Tom Lane
<tgl@sss.pgh.pa.us>, "Bossart, Nathan" <bossartn@amazon.com>,
Stephen Frost <sfrost@snowman.net>,
PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2022-02-10T19:37:06Z
Lists: pgsql-hackers
On 2/10/22 14:28, Nathan Bossart wrote: > On Wed, Feb 09, 2022 at 04:39:11PM -0500, Joe Conway wrote: >> On 2/9/22 13:13, Nathan Bossart wrote: >>> I do wonder if users find the differences between predefined roles and role >>> attributes confusing. INHERIT doesn't govern role attributes, but it will >>> govern predefined roles when this patch is applied. Maybe the role >>> attribute system should eventually be deprecated in favor of using >>> predefined roles for everything. Or perhaps the predefined roles should be >>> converted to role attributes. >> >> Yep, I was suggesting that the latter would have been preferable to me while >> Robert seemed to prefer the former. Honestly I could be happy with either of >> those solutions, but as I alluded to that is probably a discussion for the >> next development cycle since I don't see us doing that big a change in this >> one. > > I agree. I still think Joshua's proposed patch is a worthwhile improvement > for v15. +1 I am planning to get into it in detail this weekend. So far I have really just ensured it merges cleanly and passes make world. Joe -- Crunchy Data - http://crunchydata.com PostgreSQL Support for Secure Enterprises Consulting, Training, & Open Source Development
Commits
Same data as JSON:
GET /api/v1/messages/:b64id/commits
the thread's linked commits as JSON, with link sources.
API reference →
-
Fix a bug in roles_is_member_of.
- 0101f770a05b 16.0 landed
-
docs: Fix up some out-of-date references to INHERIT/NOINHERIT.
- 620ac285483f 16.0 landed
-
Allow grant-level control of role inheritance behavior.
- e3ce2de09d81 16.0 landed
-
Make role grant system more consistent with other privileges.
- ce6b672e4455 16.0 cited
-
Document basebackup_to_shell.required_role.
- 26a0c025e233 15.0 landed