User Details for PostgreSQL

From: "Kumar, Virendra" <Virendra(dot)Kumar(at)guycarp(dot)com>
To: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: User Details for PostgreSQL
Date: 2019-05-09 20:42:17
Message-ID: 7cf1fe0b6a424af9b5224d960ba2b54d@USFKL11XG20CN01.mercer.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello Team,

We are looking for some audit information about user creation. We need a few audit fields which we did not find in PostgreSQL. I would be happy if someone help us in finding these details. Besically we need information about:

1. User creation date

2. Last Password change date

Do we have a way to get these values or can somebody guide us how we can store and get these values while creating user.

Regards,
Virendra

________________________________

This message is intended only for the use of the addressee and may contain
information that is PRIVILEGED AND CONFIDENTIAL.

If you are not the intended recipient, you are hereby notified that any
dissemination of this communication is strictly prohibited. If you have
received this communication in error, please erase all copies of the message
and its attachments and notify the sender immediately. Thank you.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Christopher Browne 2019-05-09 21:04:10 Re: User Details for PostgreSQL
Previous Message Erik Jones 2019-05-09 20:03:50 Hot Standby Conflict on pg_attribute