Why no pg_has_role(..., 'ADMIN')?

Поиск
Список
Период
Сортировка
От Dominique Devienne
Тема Why no pg_has_role(..., 'ADMIN')?
Дата
Msg-id CAFCRh-8JNEy+dV4SXFOrWca50u+d=--TO4cq=+ac1oBtfJy4AA@mail.gmail.com
обсуждение исходный текст
Ответы Re: Why no pg_has_role(..., 'ADMIN')?
Список 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 по дате отправления: