Why no pg_has_role(..., 'ADMIN')? - Mailing list pgsql-general

From Dominique Devienne
Subject Why no pg_has_role(..., 'ADMIN')?
Date
Msg-id CAFCRh-8JNEy+dV4SXFOrWca50u+d=--TO4cq=+ac1oBtfJy4AA@mail.gmail.com
Whole thread Raw
Responses Re: Why no pg_has_role(..., 'ADMIN')?
List pgsql-general
To find out whether a ROLE can DROP another in v16+.
Prior to v16, just having CREATEROLE was enough,
so it didn't really seem necessary.

But knowing whether DROP ROLE will work,
w/o invalidating the current transaction,
seems like something quite useful to know now, no?

I can query pg_auth_members for admin_option,
but only easily for direct membership. Taking into
account indirect membership, which I assume applies,
is exactly why pg_has_role() exists, no?

Thanks for any insights. --DD



pgsql-general by date:

Previous
From: Ron Johnson
Date:
Subject: Re: Dependencies on the system view
Next
From: Laurenz Albe
Date:
Subject: Re: Why no pg_has_role(..., 'ADMIN')?