Re: Allow database owners to CREATE EVENT TRIGGER - Mailing list pgsql-hackers

From Aleksander Alekseev
Subject Re: Allow database owners to CREATE EVENT TRIGGER
Date
Msg-id CAJ7c6TNHc3c=V8TATcg1MJhhBNBOB7fivTUrBrZ==fv82cQzDw@mail.gmail.com
Whole thread Raw
In response to Allow database owners to CREATE EVENT TRIGGER  (Steve Chavez <steve@supabase.io>)
Responses Re: Allow database owners to CREATE EVENT TRIGGER
List pgsql-hackers
Hi,

> Unlike superuser event triggers, which execute functions for every role, database owner event triggers are only
executedfor non-superusers.
 

Even if we forget about the security aspect for a moment, personally I
have mixed feelings about the idea of adding a new type of event
trigger that looks like a regular one but works differently depending
on who creates them. Also what will happen if I promote a user to a
superuser or vice versa? All this doesn't strike me as a great UI.

Maybe you could explain your particular use case?

-- 
Best regards,
Aleksander Alekseev



pgsql-hackers by date:

Previous
From: "258790519"
Date:
Subject: Re: is git.postgresql.org working fine?
Next
From: Jacob Champion
Date:
Subject: Re: [PATCH] pg_stat_activity: make slow/hanging authentication more visible