Re: PostgreSQL trigger on user logon

Поиск
Список
Период
Сортировка
От Steve Midgley
Тема Re: PostgreSQL trigger on user logon
Дата
Msg-id CAJexoS+tj=HNSs2N1trTM0CRS2y4xsAt-5tLsGdvQbmvDmepqw@mail.gmail.com
обсуждение исходный текст
Ответ на PostgreSQL trigger on user logon  (Kevin Tu <kevintu888@gmail.com>)
Список pgsql-sql

On Fri, Mar 18, 2022 at 7:47 AM Kevin Tu <kevintu888@gmail.com> wrote:
Hi team,

We're switching over from Oracle to PostgreSQL, and apologies in advance if this is too newbie a question, but can we write a trigger in Posgres to record user logon for audit purposes? I'd thought there would be some "after/before logon trigger" that'll achieve this, but I've been googling around to no avail. 

This was discussed here last year. The net-net is to use this plugin: https://github.com/splendiddata/login_hook


Hopefully that helps!
Steve 

В списке pgsql-sql по дате отправления:

Предыдущее
От: Kevin Tu
Дата:
Сообщение: PostgreSQL trigger on user logon
Следующее
От: Jian He
Дата:
Сообщение: the order of operator computation