Re: Detect who ran DROP schema

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Detect who ran DROP schema
Дата
Msg-id CAKFQuwabzb1Ozd=oJetThJEkn5iTcCWNOyFTyaBfeCoxZMbxxQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Detect who ran DROP schema  (Siraj G <tosiraj.g@gmail.com>)
Ответы RE: [EXTERNAL] Re: Detect who ran DROP schema
Список pgsql-admin
On Wednesday, July 24, 2024, Siraj G <tosiraj.g@gmail.com> wrote:

PgSQL instance is a cloud SQL managed by GCP. I used the GCP observability tab to get the log, but I guess more logging is required to get more granular details.

Pretty sure you are sunk if you allow multiple people to connect over IP as the same user.  Though you might be able to locate a client IP address somewhere.

Be glad it was UAT and that you can learn from your mistakes with minimal damage.  Enable better logging and require personal login credentials.

David J.

В списке pgsql-admin по дате отправления: