Re: Orphaned users in PG16 and above can only be managed by Superusers - Mailing list pgsql-hackers

From Nathan Bossart
Subject Re: Orphaned users in PG16 and above can only be managed by Superusers
Date
Msg-id Z5O5ZsXDHMYFNKSs@nathan
Whole thread Raw
In response to Re: Orphaned users in PG16 and above can only be managed by Superusers  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Thu, Jan 23, 2025 at 03:10:16PM -0500, Tom Lane wrote:
> That line of reasoning leads to the same conclusion, that another
> built-in role might be a suitable solution --- unless said role is
> so powerful that the service providers might want to block access
> to it too.  Probably limiting it to manage non-superuser roles is
> good enough for that, but I'm not quite sure.

IMHO it's reasonable to expect service providers to adjust the predefined
roles if the stock limitations are not sufficient for them.

-- 
nathan



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Convert sepgsql tests to TAP
Next
From: Tom Lane
Date:
Subject: Re: pg_createsubscriber TAP test wrapping makes command options hard to read.