Guidelines for Creating Audit Trails in the Oracle Database Security Central Console

Follow these guidelines for creating transaction log audit trails for PostgreSQL database targets in the Oracle Database Security Central console.

Recommendations

Before creating the audit trails, Oracle recommends that you set the AV.COLLECTOR.TIMEZONEOFFSET attribute for the PostgreSQL database target in the Oracle Database Security Central console, because the transaction log audit trail gets the timezones of audit records from the target. Set AV.COLLECTOR.TIMEZONEOFFSET to the timezone offset of the PostgreSQL database. For example: +03:00 for positive offset and -03:00 for negative offset.

See Registering Targets for more information.

Guidelines

Use the following guidelines when you create audit trails according to the steps in Adding Audit Trails with Agent-Based Collection:

• For Trail Type, select TRANSACTION LOG.

• For Trail Location, enter the full path of the directory that contains the CDC Extract XML files.

• Ensure that the Audit Vault Agent is running on the host machine that has access to the trail location.

• Ensure that the Audit Vault Agent user has read permission for the trail location.