MIME-Version: 1.0
From: Dominique Devienne <ddevienne@gmail.com>
Date: Mon, 14 Apr 2025 10:50:57 +0200
Message-ID: <CAFCRh--7cj8WjA1173R4XD+Qvf6SWROq5iN5JB_ux32JYH9gMA@mail.gmail.com>
Subject: Event-Triggers for DB owners instead of just SUPERUSER
To: pgsql-general@lists.postgresql.org
Content-Type: text/plain; charset="UTF-8"
Archived-At: <https://www.postgresql.org/message-id/CAFCRh--7cj8WjA1173R4XD%2BQvf6SWROq5iN5JB_ux32JYH9gMA%40mail.gmail.com>
Precedence: bulk

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