Postgres Pro
Downloads
Home   >   mailing lists

Re: Require details that can we see the password history to a User account in PostgreSQL Database. - Mailing list pgsql-general

From Sonai muthu raja M
Subject Re: Require details that can we see the password history to a User account in PostgreSQL Database.
Date
Msg-id KL1PR03MB557290E2E034865A64B9032F83F19@KL1PR03MB5572.apcprd03.prod.outlook.com
Whole thread Raw
In response to Re: Require details that can we see the password history to a User account in PostgreSQL Database.  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Tree view
Dear Adrian,

Thank you so much for the provided information.

Warm regards,

M Sonai Muthu Raja
Managed Delivery Services - DBA Support
M: +919003132734
II Floor, TIDEL Park, 4 Rajiv Gandhi Salai,
Taramani, Chennai – 600 113



From: Adrian Klaver <adrian.klaver@aklaver.com>
Sent: Saturday, April 16, 2022 9:24 PM
To: Sonai muthu raja M <Sonaimuthu.Raja@sifycorp.Com>; pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>
Cc: dba_support <dba_support@sifycorp.com>
Subject: Re: Require details that can we see the password history to a User account in PostgreSQL Database.
 
WARNING: This email originated from outside of Sify domain. DO NOT click the links or open the attachments unless you recognize the sender and know the content is safe.



On 4/16/22 00:31, Sonai muthu raja M wrote:
> Dear Adrian,
>
> Yes, exactly. My query regardingan application user that when passwords
> were changed and what the previous values were?

1) Postgres has not built in process to audit changes to it's own roles.

2) That also means it does not audit whatever you are doing in the
application above it.

3) Assuming the application user information is stored in a Postgres
table you could create a trigger on the table that stores the changes in
a separate audit table.

>
> Kindly let us know the above information since this detail require for
> an internal auditing purpose.
>
> Thanks.
>
> */Warm regards,/**/
>
> M Sonai Muthu Raja


--
Adrian Klaver
adrian.klaver@aklaver.com
DISCLAIMER: The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments. Please note that intercepting or any unauthorized use of this message or any attachment can be treated as infringement of person’s right of privacy under the Human Rights Act 1993 and also is a Criminal Offence under the Information and Technology Act, 2008.

WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. Thank you for your cooperation.
Attachment

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Require details that can we see the password history to a User account in PostgreSQL Database.
Next
From: Perry Smith
Date:
Subject: Re: ***SPAM*** Re: Help with large delete