On Fri, Sep 20, 2024 at 2:34 PM Tom Lane <tgl@xxxxxxxxxxxxx> wrote: > I'm now inclined to add wording within the pg_has_role entry, along > the lines of > > WITH ADMIN OPTION or WITH GRANT OPTION can be added to any of > these privilege types to test whether ADMIN privilege is held > (all six spellings test the same thing). I don't have an opinion about the details, but +1 for documenting it somehow. I also think it's weird that we have six spellings that test the same thing, none of which are $SUBJECT. pg_has_role seems a little half-baked to me... -- Robert Haas EDB: http://www.enterprisedb.com
