Horton

Re: Q: GRANT ... WITH ADMIN on PG 17

Karsten Hilbert <karsten.hilbert@gmx.net>

View thread View on postgr.es
From: Karsten Hilbert <Karsten.Hilbert@gmx.net>
To: "David G. Johnston" <david.g.johnston@gmail.com>
Cc: Adrian Klaver <adrian.klaver@aklaver.com>, "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Date: 2025-08-21T16:17:28Z
Lists: pgsql-general 
Am Thu, Aug 21, 2025 at 09:11:57AM -0700 schrieb David G. Johnston:

> > Thanks, I did, but did not find the answer to: Is there a
> > way for a role that can manage membership in a group role to
> > not itself be a member of that group role ?
> 
> A superuser can do this.  Otherwise, no.  In order to be made admin of a
> role on must be a member of said role

Thanks, fine, that makes it clear to me.

Regards,
Karsten
-- 
GPG  40BE 5B0E C98E 1713 AFA6  5BC0 3BEA AC80 7D4F C89B