Re: DROP ROLE as SUPERUSER

["David G. Johnston" <david.g.johnston@xxxxxxxxx>]

On Thu, Feb 20, 2025 at 9:21 AM Dominique Devienne <ddevienne@xxxxxxxxx> wrote:

But that's not much better. It's basically like the SET ROLE to the GRANTOR I did.

I guess what I want is GRANTED BY ANYONE! And not have to figure out GRANTOR(s).

Your stated use case is dropping a role.  Does the combination of reassign and drop owned not fulfill the requirements?

https://www.postgresql.org/docs/current/role-removal.html

Also, you had to know the role you wanted to drop so you already figured out the grantor.

David J.