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@xxxxxxxxxxx
