public inbox for [email protected]  

help / color / mirror / Atom feed

From: Dominique Devienne <[email protected]>
To: [email protected]
Subject: Event-Triggers for DB owners instead of just SUPERUSER
Date: Mon, 14 Apr 2025 10:50:57 +0200
Message-ID: <CAFCRh--7cj8WjA1173R4XD+Qvf6SWROq5iN5JB_ux32JYH9gMA@mail.gmail.com> (raw)

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

view thread (3+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: Event-Triggers for DB owners instead of just SUPERUSER
  In-Reply-To: <CAFCRh--7cj8WjA1173R4XD+Qvf6SWROq5iN5JB_ux32JYH9gMA@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox