Re: CREATEROLE and role ownership hierarchies

Mark Dilger <mark.dilger@enterprisedb.com>

From: Mark Dilger <mark.dilger@enterprisedb.com>

To: Shinya Kato <Shinya11.Kato@oss.nttdata.com>

Cc: "Bossart, Nathan" <bossartn@amazon.com>, PostgreSQL-development <pgsql-hackers@postgresql.org>, Andrew Dunstan <andrew@dunslane.net>, Jeff Davis <pgsql@j-davis.com>

Date: 2021-12-22T01:25:54Z

Lists: pgsql-hackers


> On Dec 21, 2021, at 5:11 PM, Shinya Kato <Shinya11.Kato@oss.nttdata.com> wrote:
> 
> I fixed the patches because they cannot be applied to HEAD.

Thank you.

—
Mark Dilger
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

Commits

Make role grant system more consistent with other privileges.
- ce6b672e4455 16.0 landed
Ensure that pg_auth_members.grantor is always valid.
- 6566133c5f52 16.0 landed
Remove the ability of a role to administer itself.
- 79de9842ab03 15.0 landed
Add tests of the CREATEROLE attribute
- e9d4001ec592 15.0 landed
Replace explicit PIN entries in pg_depend with an OID range test.
- a49d08123599 15.0 cited
Shore up ADMIN OPTION restrictions.
- fea164a72a7b 9.4.0 cited
Add pg_has_role() family of privilege inquiry functions modeled after the
- f9fd1764615e 8.1.0 cited
Align GRANT/REVOKE behavior more closely with the SQL spec, per discussion
- 4b2dafcc0b1a 8.0.0 cited