Some additional information:-
select relfilenode from pg_class where relname = 'vw_tab_mcm_net_temp_yield';
is giving the following output 0 0
-------- Original message --------
From: M Sarwar <sarwarmd02@xxxxxxxxxxx>
Date: 6/6/24 5:06 PM (GMT-05:00)
To: pgsql-admin@xxxxxxxxxxxxxxxxxxxx
Subject: How to find the view modified date and time and user name
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.
Sarwar
Sent from my Galaxy
|