Re: CREATE ROLE bug? - Mailing list pgsql-hackers

From David G. Johnston
Subject Re: CREATE ROLE bug?
Date
Msg-id CAKFQuwYVK6xfg-WqJuavjrB4A4PKWEsU39pgAkQ0S+NdwmM9wg@mail.gmail.com
Whole thread Raw
In response to Re: CREATE ROLE bug?  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
On Wed, Jan 25, 2023 at 10:21 AM Robert Haas <robertmhaas@gmail.com> wrote:
I think that the desire to maintain
the distinction between membership and ADMIN OPTION makes sense as a
general rule

I haven't worked through the details but I suspect part of the issue is that we are not maintaining this distinction when it comes to prohibiting circular dependencies.  Might it be that we need to check for and prohibit the admin and the set/inherit loops separately, but allow for an overall loop so long as one direction is strictly admin and one direction is strictly set/inherit?

David J.

pgsql-hackers by date:

Previous
From: Mohamed Badawy
Date:
Subject: Inquiry About Google Summer of Code Projects
Next
From: Tom Lane
Date:
Subject: Re: Failed assertion with jit enabled