Re: Allow database owners to CREATE EVENT TRIGGER

From: Aleksander Alekseev <aleksander(at)timescale(dot)com>
To: Steve Chavez <steve(at)supabase(dot)io>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Allow database owners to CREATE EVENT TRIGGER
Date: 2025-03-05 13:46:05
Message-ID: CAJ7c6TNHc3c=V8TATcg1MJhhBNBOB7fivTUrBrZ==fv82cQzDw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

> Unlike superuser event triggers, which execute functions for every role, database owner event triggers are only executed for 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jacob Champion 2025-03-05 13:47:08 Re: [PATCH] pg_stat_activity: make slow/hanging authentication more visible
Previous Message 258790519 2025-03-05 13:30:33 Re: is git.postgresql.org working fine?