Re: Event trigger and CREATE/ALTER ROLE/USER

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: Event trigger and CREATE/ALTER ROLE/USER
Дата
Msg-id CAB7nPqTABi3YJ++N9T-BKEJQTDoYgWU2DBfywDtXFFf0ch6D=A@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Event trigger and CREATE/ALTER ROLE/USER  (Tatsuo Ishii <ishii@sraoss.co.jp>)
Ответы Re: Event trigger and CREATE/ALTER ROLE/USER  (Tatsuo Ishii <ishii@sraoss.co.jp>)
Список pgsql-hackers
On Wed, Sep 14, 2016 at 9:34 AM, Tatsuo Ishii <ishii@sraoss.co.jp> wrote:
>>> Simple question: Is there any reason for event trigger to not support
>>> CREATE/ALTER ROLE/USER?
>>
>> Because it performs a global administrative task, no?
>
> So is there any technical difficulty?

I don't recall the exact details but...

> Can you please elaborate?

Roles are global objects, and event triggers cannot operate on such
ones. See for example 296f3a60 mentioning for example why REVOKE/GRANT
can only operate on local objects.
-- 
Michael



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

Предыдущее
От: Tatsuo Ishii
Дата:
Сообщение: Re: Event trigger and CREATE/ALTER ROLE/USER
Следующее
От: Tatsuo Ishii
Дата:
Сообщение: Re: Event trigger and CREATE/ALTER ROLE/USER