| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | Sonai muthu raja M <Sonaimuthu(dot)Raja(at)sifycorp(dot)Com>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Cc: | dba_support <dba_support(at)sifycorp(dot)com> |
| Subject: | Re: Require details that can we see the password history to a User account in PostgreSQL Database. |
| Date: | 2022-04-16 15:54:00 |
| Message-ID: | 10103f4c-5afb-8f61-cc81-4011ee8dbda7@aklaver.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sonai muthu raja M | 2022-04-16 15:56:35 | Re: Require details that can we see the password history to a User account in PostgreSQL Database. |
| Previous Message | Tom Lane | 2022-04-16 15:33:57 | Re: Help with large delete |