Postgres Pro
Downloads
Home   >   mailing lists

Re: Event trigger and CREATE/ALTER ROLE/USER - Mailing list pgsql-hackers

From Michael Paquier
Subject Re: Event trigger and CREATE/ALTER ROLE/USER
Date
Msg-id CAB7nPqTABi3YJ++N9T-BKEJQTDoYgWU2DBfywDtXFFf0ch6D=A@mail.gmail.com
Whole thread Raw
In response to Re: Event trigger and CREATE/ALTER ROLE/USER  (Tatsuo Ishii <ishii@sraoss.co.jp>)
Responses Re: Event trigger and CREATE/ALTER ROLE/USER  (Tatsuo Ishii <ishii@sraoss.co.jp>)
List pgsql-hackers
Tree view 
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 by date:

Previous
From: Tatsuo Ishii
Date:
Subject: Re: Event trigger and CREATE/ALTER ROLE/USER
Next
From: Tatsuo Ishii
Date:
Subject: Re: Event trigger and CREATE/ALTER ROLE/USER