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
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 |