Event-Triggers for DB owners instead of just SUPERUSER - Mailing list pgsql-general

From Dominique Devienne
Subject Event-Triggers for DB owners instead of just SUPERUSER
Date
Msg-id CAFCRh--7cj8WjA1173R4XD+Qvf6SWROq5iN5JB_ux32JYH9gMA@mail.gmail.com
Whole thread Raw
Responses Re: Event-Triggers for DB owners instead of just SUPERUSER
List 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



pgsql-general by date:

Previous
From: Thomas Michael Engelke
Date:
Subject: ICU Collations and Collation Updates
Next
From: Wolfgang Walther
Date:
Subject: Re: Event-Triggers for DB owners instead of just SUPERUSER