Retrieving Audit Policies from an Oracle Database

You can retrieve audit policies from Oracle database.

Understanding the Columns on the Audit Policies Tab

When you retrieve audit policies from a target Oracle Database, you see the state of the database audit policies at that point in time.

1. Select Policies in the Oracle Database Security Central console.

2. Select Audit Policies in the left navigation menu.

   This page contains a list of Oracle Database targets. It also lists the number of enabled audit policies of each type and when the audit policies were last retrieved.

Retrieving Audit Policies from Multiple Oracle Databases

You can retrieve audit policies from several Oracle Database targets at once. You can schedule audit policy retrieval for individual targets.

Prerequisite:

Ensure the target user has sufficient privileges granted for audit policy management. An administrator can grant these using the Oracle Database Setup Scripts.

Note: After upgrading to Oracle DBSecCentral you must rerun the Oracle privileges script for successful audit policy retrieval. For more information see Oracle Database Setup Scripts.

1. Log in to Oracle Database Security Central Console as an auditor.

2. Select Policies.

3. Select Audit Policies in the left navigation menu.

   This page lists a summary of audit policies at this point in time for all Oracle targets with their status.

4. In the Target column, select the check boxes for the target databases that you want to retrieve audit policies. You can only see the Oracle database targets to which you have access.

5. Select Retrieve policies.

   To check the status of the retrieval, select Settings, then Jobs tab in the left navigation menu. When the audit policies retrieval is complete, the Retrieve Audit policies job is displayed on this page under Job Type column.

Note:

• Traditional auditing is desupported in Oracle AI Database 26ai. Oracle recommends that you use unified auditing instead. You cannot manage traditional audit settings from the Oracle Database Security Central console for Oracle AI Database 26ai and later releases. For more information see Handling the Desupport of Traditional Auditing in the Oracle AI Database Security Guide and Traditional Auditing Desupported in the Oracle AI Database Upgrade Guide.

• All audit policy data will be purged after 6 months from the time of data retrieval.

Related Topics

• Scheduling the Retrieval of Audit Policies for an Oracle Database

• Understanding the Columns on the Audit Policies Tab

Scheduling the Retrieval of Audit Policies for an Oracle Database

You can schedule the retrieval of audit policies for an Oracle Database target to periodically synchronize audit policies with Oracle Database Security Central.

1. Log in to Oracle Database Security Central Console as an auditor.

2. Select Policies.

3. On the Policy Console, select the databases to schedule retrieval for from the Policies retrieval schedule for Oracle Databases table.

4. Select Schedule Retrieval.

5. Select the policy types to retrieve.

6. Set the retrieval schedule.

7. Select Save.