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

From: Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net>
To: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
Cc: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Q: GRANT ... WITH ADMIN on PG 17
Date: 2025-08-21 16:17:28
Message-ID: aKdGmG5uKpMQBamy@hermes.hilbert.loc
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dominique Devienne 2025-08-21 16:29:36 Re: Q: GRANT ... WITH ADMIN on PG 17
Previous Message David G. Johnston 2025-08-21 16:11:57 Re: Q: GRANT ... WITH ADMIN on PG 17