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

From: Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net>
To: Dominique Devienne <ddevienne(at)gmail(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Q: GRANT ... WITH ADMIN on PG 17
Date: 2025-08-21 16:37:47
Message-ID: aKdLW7a-MN8vlKnJ@hermes.hilbert.loc
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

Am Thu, Aug 21, 2025 at 06:29:36PM +0200 schrieb Dominique Devienne:

> > 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 ?
>
> Yes and no. Depends what you mean by MEMBER...
...
> So I didn't spend time studying your specific use case. That's your job :).
> But given my painful experience of the past year, I'd answer yes to your
> question, on logical grounds. If you see what I mean. --DD

I followed your posts back then when you worked out your use
case so I did have _some_ idea where to look ;-)

I just wanted to confirm my understanding in relation to my
current usage. David kindly provided the needed affirmation.

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dominique Devienne 2025-08-21 16:43:47 Re: Q: GRANT ... WITH ADMIN on PG 17
Previous Message Dominique Devienne 2025-08-21 16:29:36 Re: Q: GRANT ... WITH ADMIN on PG 17