Re: Event trigger and CREATE/ALTER ROLE/USER

From: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
To: Tatsuo Ishii <ishii(at)sraoss(dot)co(dot)jp>
Cc: PostgreSQL mailing lists <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Event trigger and CREATE/ALTER ROLE/USER
Date: 2016-09-14 00:41:54
Message-ID: CAB7nPqTABi3YJ++N9T-BKEJQTDoYgWU2DBfywDtXFFf0ch6D=A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, Sep 14, 2016 at 9:34 AM, Tatsuo Ishii <ishii(at)sraoss(dot)co(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tatsuo Ishii 2016-09-14 00:50:12 Re: Event trigger and CREATE/ALTER ROLE/USER
Previous Message Tatsuo Ishii 2016-09-14 00:34:42 Re: Event trigger and CREATE/ALTER ROLE/USER