Thread

1. PostgreSQL trigger on user logon

   Kevin Tu <kevintu888@gmail.com> — 2022-03-18T14:46:35Z

   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
   

2. Re: PostgreSQL trigger on user logon

   Steve Midgley <science@misuse.org> — 2022-03-18T19:58:02Z

   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