Re: Detect who ran DROP schema

Поиск
Список
Период
Сортировка
От Laurenz Albe
Тема Re: Detect who ran DROP schema
Дата
Msg-id 0be99bd63697f6a49e2b14c7542c820448ade8e4.camel@cybertec.at
обсуждение исходный текст
Ответ на Detect who ran DROP schema  (Siraj G <tosiraj.g@gmail.com>)
Список pgsql-admin
On Wed, 2024-07-24 at 12:44 +0530, Siraj G wrote:
> A schema was dropped from our UAT environment on 18th July. We are trying to
> find out who did. We have only one user in our environment, i.e., postgres,
> but we are trying to identify from where the connection was initiated, which
> issued DROP schema. Can anyone help?

Unless you have configured logging, nobody can figure that out.

Among the things you are doing wrong is that you are using a superuser.

Yours,
Laurenz Albe



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