Re: How to find the view modified date and time and user name

[M Sarwar <sarwarmd02@xxxxxxxxxxx>]

David,

Thanks for the update!

---

From: David G. Johnston <david.g.johnston@xxxxxxxxx>
Sent: Thursday, June 6, 2024 5:49 PM
To: M Sarwar <sarwarmd02@xxxxxxxxxxx>
Cc: pgsql-admin@xxxxxxxxxxxxxxxxxxxx <pgsql-admin@xxxxxxxxxxxxxxxxxxxx>
Subject: Re: How to find the view modified date and time and user name

 

On Thursday, June 6, 2024, M Sarwar <sarwarmd02@xxxxxxxxxxx> wrote:

Hello,

Today in our environment, we noticed that view is altered by someone.

We want to know the date, time and modified user name.

Our environment :

1. aws / rds

2. Postgress 13.5

3. database with default configuration is running

We have not enabled any additional audit, security on top of default configuration.

I have check led aws / rds / Instance / database / logs and events / log / all today's logs

and could not find any evidence.

Any hint / help will be greatly appreciated.

If you didn’t take steps to record such information it doesn’t exist.

David J.