Event-Triggers for DB owners instead of just SUPERUSER

From: Dominique Devienne <ddevienne(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Event-Triggers for DB owners instead of just SUPERUSER
Date: 2025-04-14 08:50:57
Message-ID: CAFCRh--7cj8WjA1173R4XD+Qvf6SWROq5iN5JB_ux32JYH9gMA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi.

I'd like to use CREATE EVENT TRIGGER, but they are SUPERUSER only.

In the past, CREATE EXTENSION was also SUPERUSER-only, but is now also
available to DB owners. Which is great!

Can't event-triggers also be available to DB owbers, instead of just SUPERUSER?

Having CREATEDB does not imply having SUPERUSER, and I find it very
limiting that the DB owner cannot setup things like event-triggers
(for "local" auditing purposes) on its own DB.

Is this something that has been considered before?
Any technical issues to enable / add it, in the future?

In general, can't the DB owner be considered a mini-SUPERUSER for
anything related to that one DB?

Thanks, --DD

[1]: https://www.postgresql.org/docs/current/sql-createeventtrigger.html

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Wolfgang Walther 2025-04-14 10:09:47 Re: Event-Triggers for DB owners instead of just SUPERUSER
Previous Message Thomas Michael Engelke 2025-04-14 08:28:12 ICU Collations and Collation Updates