Trigger when user logs in

Поиск
Список
Период
Сортировка
От Ron
Тема Trigger when user logs in
Дата
Msg-id eb44b902-9c08-8489-7d32-79d889d9e229@gmail.com
обсуждение исходный текст
Ответы Re: Trigger when user logs in  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Hi,

PCI auditors have mandated that our databases (all running v9.6) send an 
email when certain users log in.  Thus, I've been searching for how to do 
this, but without much luck.

https://www.postgresql.org/message-id/flat/20170720204733.40f2b7eb.nagata%40sraoss.co.jp

This long thread from almost two years ago seems to point in the right 
direction, but then died with "Okay, this has proved to require broader 
changes than thought first. I am marking the patch as returned with feedback."

So, is there something that I've missed which lets me write an "on login" 
trigger, or do I have to install pgaudit and tail_n_mail?

Thanks

-- 
Angular momentum makes the world go 'round.



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

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: shared_buffers on Big RAM systems
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Trigger when user logs in