Postgres Pro
Downloads
Home   >   mailing lists

Re: How to find the view modified date and time and user name - Mailing list pgsql-admin

From David G. Johnston
Subject Re: How to find the view modified date and time and user name
Date
Msg-id CAKFQuwa3OTdN6h8gOJRscFYxaqCkn4Ex2RWF1TsrwnScBoO7VA@mail.gmail.com
Whole thread Raw
In response to How to find the view modified date and time and user name  (M Sarwar <sarwarmd02@outlook.com>)
Responses Re: How to find the view modified date and time and user name
Re: How to find the view modified date and time and user name
List pgsql-admin
Tree view


On Thursday, June 6, 2024, M Sarwar <sarwarmd02@outlook.com> 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.
 

pgsql-admin by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: How to find the view modified date and time and user name
Next
From: Ron Johnson
Date:
Subject: Re: How to find the view modified date and time and user name