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

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: M Sarwar <sarwarmd02(at)outlook(dot)com>
Cc: "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: How to find the view modified date and time and user name
Date: 2024-06-06 21:49:11
Message-ID: CAKFQuwa3OTdN6h8gOJRscFYxaqCkn4Ex2RWF1TsrwnScBoO7VA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Thursday, June 6, 2024, M Sarwar <sarwarmd02(at)outlook(dot)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.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ron Johnson 2024-06-07 00:47:06 Re: How to find the view modified date and time and user name
Previous Message David G. Johnston 2024-06-06 21:48:22 Re: How to find the view modified date and time and user name