Re: v16 roles, SET FALSE, INHERIT FALSE, ADMIN FALSE

Поиск
Список
Период
Сортировка
От Christophe Pettus
Тема Re: v16 roles, SET FALSE, INHERIT FALSE, ADMIN FALSE
Дата
Msg-id 6A063ECC-E0FD-4CAF-A057-96BA55832889@thebuild.com
обсуждение исходный текст
Ответ на Re: v16 roles, SET FALSE, INHERIT FALSE, ADMIN FALSE  (Christophe Pettus <xof@thebuild.com>)
Ответы Re: v16 roles, SET FALSE, INHERIT FALSE, ADMIN FALSE
Список pgsql-general

> On Jul 8, 2024, at 13:29, Christophe Pettus <xof@thebuild.com> wrote:
>
>
>
>> On Jul 8, 2024, at 13:25, Laurenz Albe <laurenz.albe@cybertec.at> wrote:
>> I didn't test it, but doesn't that allow the member rule to drop objects owned
>> be the role it is a member of?
>
> No, apparently not.

Just from a quick check, it looks like you need INHERIT to inherit the ability to drop objects.  The documentation
stronglyimplies this, although it doesn't quite come out and say it. 


В списке pgsql-general по дате отправления:

Предыдущее
От: Christophe Pettus
Дата:
Сообщение: Re: v16 roles, SET FALSE, INHERIT FALSE, ADMIN FALSE
Следующее
От: Tom Lane
Дата:
Сообщение: Re: v16 roles, SET FALSE, INHERIT FALSE, ADMIN FALSE