Unified Audit Policy Name Not Recorded For Data Pump Actions in UNIFIED_AUDIT_TRAIL. UNIFIED_AUDIT_POLICIES column is null for AUDIT_TYPE 'Datapump' (Doc ID 2304486.1)

Last updated on SEPTEMBER 06, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

When auditing datapump operations, UNIFIED_AUDIT_POLICIES column in UNIFIED_AUDIT_TRAIL always shows NULL.

 

By this symptom, user cannot confirm the policy information which is related with the audit record of datapump.

Changes

 TESTCASE STEPS:

SQL> CREATE AUDIT POLICY <policy name> ACTIONS COMPONENT=datapump ALL;

Audit policy created.

SQL> audit policy <policy name>;

Audit succeeded.

SQL> create user <user> identified by **;

User created.

SQL> grant connect,dba to <user>;

Grant succeeded.

$ expdp <user>/<password> tables=<T1> dumpfile=exp.dmp logfile=explog.log

sqlplus / as sysdba

SQL> select dbusername, action_name, unified_audit_policies from
unified_audit_trail where dp_text_parameters1 is not null;

DBUSERNAME
------------------------------
ACTION_NAME
----------------------------------------------------------------
UNIFIED_AUDIT_POLICIES
------------------------------------------------------------------------------
--
<user>
EXPORT

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms