Re: Delegating superuser tasks to new security roles (Was: Granting control of SUSET gucs to non-superusers)

From: Mark Dilger <mark(dot)dilger(at)enterprisedb(dot)com>
To: Andrew Dunstan <andrew(at)dunslane(dot)net>
Cc: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Stephen Frost <sfrost(at)snowman(dot)net>, Robert Haas <robertmhaas(at)gmail(dot)com>, Noah Misch <noah(at)leadboat(dot)com>, Jacob Champion <pchampion(at)vmware(dot)com>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>, "tgl(at)sss(dot)pgh(dot)pa(dot)us" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Bossart, Nathan" <bossartn(at)amazon(dot)com>, "chap(at)anastigmatix(dot)net" <chap(at)anastigmatix(dot)net>, torikoshia <torikoshia(at)oss(dot)nttdata(dot)com>, Nathan wrote <bossartn(at)amazon(dot)com>, Ronan Dunklau <ronan(dot)dunklau(at)aiven(dot)io>
Subject: Re: Delegating superuser tasks to new security roles (Was: Granting control of SUSET gucs to non-superusers)
Date: 2021-10-20 18:39:52
Message-ID: AAD45C26-DB4B-42DF-9145-927B36690FA1@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I have now received multiple requests to split this patchset into multiple parts, including some off-list. I'll be posting four new patch sets on four new topics:

New privileged roles which can SET and ALTER SYSTEM SET (v8-0002 through v8-0013)

Non-superuser event trigger owners (v8-0014 and v8-0015)

Non-superuser subscription owners (v8-0016 through v8-0018)

CREATEROLE and role ownership hierarchies (v8-0001 and v8-0019 through v8-0021)

I cannot presume everyone will be interested, so I will only cc'd Andrew on the new threads, given his status as a reviewer. I don't mean by this to cut anyone out of the discussion.


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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Mark Dilger 2021-10-20 18:40:10 New privileged roles which can SET and ALTER SYSTEM SET
Previous Message John Naylor 2021-10-20 18:33:15 Re: [RFC] speed up count(*)