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.
SELECT
COPY
WRITE: INSERT, UPDATE, DELETE, TRUNCATE, and COPY when the destination is a relation.
INSERT
UPDATE
DELETE
TRUNCATE
FUNCTION: Function calls and DO blocks.
DO
ROLE: Statements related to roles and privileges: GRANT, REVOKE, CREATE/ALTER/DROP ROLE.
GRANT
REVOKE
CREATE/ALTER/DROP ROLE
DDL: All DDL that is not included in the ROLEclass.
DDL
ROLE
MISC: Miscellaneous commands, e.g. DISCARD, FETCH, CHECKPOINT, VACUUM, SET.
DISCARD
FETCH
CHECKPOINT
VACUUM
SET
MISC_SET: Miscellaneous SET commands, e.g. SET ROLE.
SET ROLE
ALL: Include all of the above.
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 advanceTejas
pgsql-admin by date:
Соглашаюсь с условиями обработки персональных данных
