Re: Auditing in Postgres

[Anjul Sahu <anjul@xxxxxxxxxxxx>]

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:

• READ: SELECT and COPY when the source is a relation or a query.

• WRITE: INSERT, UPDATE, DELETE, TRUNCATE, and COPY when the destination is a relation.

• FUNCTION: Function calls and DO blocks.

• ROLE: Statements related to roles and privileges: GRANT, REVOKE, CREATE/ALTER/DROP ROLE.

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

• MISC: Miscellaneous commands, e.g. DISCARD, FETCH, CHECKPOINT, VACUUM, SET.

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

• ALL: Include all of the above.

Thanks,

Anjul Sahu

Founder and CEO

Cloudraft

Email: anjul@xxxxxxxxxxxx 

Phone: +916268918953

On Tue, 9 Apr 2024 at 5:30 PM, Tejaswi K T <tejaswi.kt@xxxxxxxxx> 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