Event-Triggers for DB owners instead of just SUPERUSER

Поиск
Список
Период
Сортировка
От Dominique Devienne
Тема Event-Triggers for DB owners instead of just SUPERUSER
Дата
Msg-id CAFCRh--7cj8WjA1173R4XD+Qvf6SWROq5iN5JB_ux32JYH9gMA@mail.gmail.com
обсуждение исходный текст
Ответы Re: Event-Triggers for DB owners instead of just SUPERUSER
Список 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 по дате отправления: