Re: Trigger when user logs in

From: Ron <ronljohnsonjr(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Forums postgresql <pgsql-general(at)postgresql(dot)org>
Subject: Re: Trigger when user logs in
Date: 2019-04-12 02:28:41
Message-ID: d0b376b1-dedf-64c7-8d00-8aaa132177d4@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 4/11/19 9:12 PM, Tom Lane wrote:
> Ron <ronljohnsonjr(at)gmail(dot)com> writes:
>> 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.
> PAM is the usual suggestion

Can you be more specific?  (All users except postgres log in directly to the
database from remote systems.)

> when you need off-the-beaten-path login behavior.

I bet requests like this will start to make it onto the beaten path.

--
Angular momentum makes the world go 'round.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2019-04-12 02:52:42 Re: Trigger when user logs in
Previous Message Tom Lane 2019-04-12 02:12:41 Re: Trigger when user logs in