Thread: PostgreSQL trigger on user logon
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.
Best Regards,
Kevin
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
There were other options discussed - you can browse the thread here: https://www.postgresql.org/message-id/CAN0SRDFZ-cDbuiu-_8oA4W1pU_oYkksydj8f2o7%2BO7XUwUfN4w%40mail.gmail.com
Hopefully that helps!
Steve