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

From: M Sarwar <sarwarmd02(at)outlook(dot)com>
To: "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: How to find the view modified date and time and user name
Date: 2024-06-06 21:06:05
Message-ID: DM4PR19MB597864190796CC5828854176D3FA2@DM4PR19MB5978.namprd19.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message M Sarwar 2024-06-06 21:11:48 RE: How to find the view modified date and time and user name
Previous Message Ron Johnson 2024-06-06 13:33:07 Re: Minimize checkpointer and walwriter io during pg_restore