Re: DROP ROLE as SUPERUSER

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: DROP ROLE as SUPERUSER
Дата
Msg-id CAKFQuwYxPq4UNkiRODjQu8KkqOE9G0r1CpoX6ZvfiGab62N9dw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: DROP ROLE as SUPERUSER  (Dominique Devienne <ddevienne@gmail.com>)
Список pgsql-general
Дерево обсуждения
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 по дате отправления: