Re: Auditing in Postgres

Поиск
Список
Период
Сортировка
От Anjul Sahu
Тема Re: Auditing in Postgres
Дата
Msg-id CAJvjyb80jhOzpg4GNj49GWmxHuPwCb0Q140jo6qx4xum4yBD+w@mail.gmail.com
обсуждение исходный текст
Ответ на [MASSMAIL]Auditing in Postgres  (Tejaswi K T <tejaswi.kt@gmail.com>)
Список pgsql-admin
Hi Tejaswi

You can check in Pgaudit docs.

pgaudit.log

Specifies which classes of statements will be logged by session audit logging. Possible values are:

  • READSELECT and COPY when the source is a relation or a query.

  • WRITEINSERTUPDATEDELETETRUNCATE, and COPY when the destination is a relation.

  • FUNCTION: Function calls and DO blocks.

  • ROLE: Statements related to roles and privileges: GRANTREVOKECREATE/ALTER/DROP ROLE.

  • DDL: All DDL that is not included in the ROLEclass.

  • MISC: Miscellaneous commands, e.g. DISCARDFETCHCHECKPOINTVACUUMSET.

  • MISC_SET: Miscellaneous SET commands, e.g. SET ROLE.

  • ALL: Include all of the above.



Thanks,

Anjul Sahu
Founder and CEO
Phone: +916268918953


On Tue, 9 Apr 2024 at 5:30 PM, Tejaswi K T <tejaswi.kt@gmail.com> wrote:
Hi Team,
I am from an oracle background and new to postgres.

We recently provisioned postgres database for our application, and have a requirement.

Our banking organisation, we have enabled auditing to capture all failed DML , in oracle we do with commands like 
AUDIT INSERT ANY TABLE WHENEVER NOT SUCCESSFUL; 

Do we have similar commands in pgaudit , which captures only failed DML and not the successful ones. 

In OLTP, we have millions of data inserts and we are not interested in capturing all successful inserts. 

thanks in advance
Tejas

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

Предыдущее
От: Tejaswi K T
Дата:
Сообщение: [MASSMAIL]Auditing in Postgres
Следующее
От: Scott Ribe
Дата:
Сообщение: Re: Auditing in Postgres