EnterpriseDB Supplemental Guide: View Audit Logs

2.2.2 View Audit Logs

In the DBA Management Server, select the View Audit Logs option from the Monitoring menu to see auditing information.

Figure 22 View Audit Logs

In the View Audit report, the audit options selected in the postgresql.conf file are shown on the left-hand side of the screen. The checkboxes in the middle of the screen provide for further screening of the types of statements that are to be shown in the report.

Figure 23 View Audit

The audited statements were generated by the following session in PSQL.

edb=# CREATE TABLE test (f1 INTEGER);
CREATE TABLE
edb=# INSERT INTO test VALUES (100);
INSERT 0 1
edb=# SELECT * FROM testx;
ERROR:  relation "testx" does not exist
edb=# DROP TABLE test;
DROP TABLE

Note that the successful INSERT command does not appear in the audit list since edb_audit_statement was not set to include successful DML commands.