Postgres Pro
Downloads
Home   >   mailing lists

Re: DROP ROLE as SUPERUSER - Mailing list pgsql-general

From David G. Johnston
Subject Re: DROP ROLE as SUPERUSER
Date
Msg-id CAKFQuwYxPq4UNkiRODjQu8KkqOE9G0r1CpoX6ZvfiGab62N9dw@mail.gmail.com
Whole thread Raw
In response to Re: DROP ROLE as SUPERUSER  (Dominique Devienne <ddevienne@gmail.com>)
List pgsql-general
Tree view
On Thu, Feb 20, 2025 at 9:21 AM Dominique Devienne <ddevienne@gmail.com> 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.


pgsql-general by date:

Previous
From: Dominique Devienne
Date:
Subject: Re: DROP ROLE as SUPERUSER
Next
From: Tom Lane
Date:
Subject: Re: DROP ROLE as SUPERUSER