Re: Users and object privileges maintenance

Поиск
Список
Период
Сортировка
От Dominique Devienne
Тема Re: Users and object privileges maintenance
Дата
Msg-id CAFCRh-_qYCD4Ex1KfL5Vmer_cwvqvagzKo0Xn2L2_iU3domWqQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Users and object privileges maintenance  (Pavel Luzanov <p.luzanov@postgrespro.ru>)
Ответы Re: Users and object privileges maintenance
Список pgsql-general
Дерево обсуждения
On Sun, Feb 18, 2024 at 4:33 PM Pavel Luzanov <p.luzanov@postgrespro.ru> wrote:
On 18.02.2024 17:40, Dominique Devienne wrote:
Well, membership in a role mean you can "become that role", no? Thus this seems logical,
and not confusing to me, that you can act as the owner, since you SET ROLE to the owner.
They may acts as the owner even without explicit SET ROLE to the owner.
It wasn't obvious to me when I came to postgres from oracle.
Well, that depends on INHERIT on the ROLE, and since v16 on the membership GRANT, probably.
But that's a good point, worth mentioning indeed. As I wrote, understanding INHERIT is important. --DD

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

Предыдущее
От: Laura Smith
Дата:
Сообщение: Re: Function inserting into tstzrange ? (syntax error at or near...)
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Function inserting into tstzrange ? (syntax error at or near...)