# Oracle 12c Unified Auditing - Mixed Mode

- URL: https://www.integrigy.com/oracle-security-blog/oracle-12c-unified-auditing-mixed-mode
- Published: 2014-11-21
- Type: Blog Post
- Products: Oracle Database
- Focus areas: Auditing

Next in our blog series on Oracle 12 Unified Auditing is a discussion of Mixed Mode. Mixed Mode is the default auditing mode for Oracle 12c. Oracle describes Mixed Mode auditing as a means of becoming familiar with Unified Auditing prior to migrating to Pure Unified Auditing. Mixed Mode allows for all traditional, pre-12c log and audit functionality to co-exist with Unified Auditing. More importantly, Mixed Mode will support any current Syslog-based logging solution.

Mixed mode auditing provides the following key capabilities –

- All existing (pre-12c) auditing initialization configurations and parameters are used such as `AUDIT_TRAIL`, `AUDIT_FILE_DEST`, `AUDIT_SYS_OPERATIONS`, and `AUDIT_SYSLOG_LEVEL`
- The format of the audit records remains the same as in Oracle Database 11*g* Release 2
- Writes mandatory audit records to the traditional audit trails
- If the `AUDIT_SYS_OPERATIONS` initialization parameter is set to `TRUE`, writes audit records only to the traditional audit trails

With Mixed Mode, audit data can be found both in the traditional locations as well as in SYS.UNIFIED_AUDIT_TRAIL. This is because the Unified Auditing Policy ORA_SECURECONFIG is enabled by default. ORA_SECURECONFIG audits the same default audit settings from Oracle Database Release 11*g.* Integrigy recommends to either periodically purge Unified Auditing data or disable the policy. To disable ORA_SECURECONFIG policy follow the instructions in Oracle Support Note [Doc ID 1624051.1](https://support.oracle.com/rs?type=doc\&id=1624051.1).

The following table shows the definition of the default policy ORA_SECURECONFIG. Note the column ‘Common’ that shows that the policy is defined for all PDBs (tenant) databases.

<table>
<thead>
<tr>
<th colspan="4"><p><strong>Mixed Mode Default Unified Policy ORA_SECURECONFIG</strong></p></th>
</tr>
<tr>
<th><p><strong>Audit Option</strong></p></th>
<th><p><strong>Option Type</strong></p></th>
<th><p><strong>Common</strong></p></th>
<th><p><strong>Integrigy Framework</strong></p></th>
</tr>
</thead>
<tbody>
<tr>
<td><p>ADMINISTER KEY MANAGEMENT</p></td>
<td><p>SYSTEM PRIVILEGE</p></td>
<td><p>YES</p></td>
<td><p>E11 - Privileged commands</p></td>
</tr>
<tr>
<td><p>ALTER ANY PROCEDURE</p></td>
<td><p>SYSTEM PRIVILEGE</p></td>
<td><p>YES</p></td>
<td><p>E13 – Objects</p></td>
</tr>
<tr>
<td><p>ALTER ANY SQL TRANSLATION PROFILE</p></td>
<td><p>SYSTEM PRIVILEGE</p></td>
<td><p>YES</p></td>
<td><p>E11 - Privileged commands</p></td>
</tr>
<tr>
<td><p>ALTER ANY TABLE</p></td>
<td><p>SYSTEM PRIVILEGE</p></td>
<td><p>YES</p></td>
<td><p>E13 – Objects</p></td>
</tr>
<tr>
<td><p>ALTER DATABASE</p></td>
<td><p>SYSTEM PRIVILEGE</p></td>
<td><p>YES</p></td>
<td><p>E11 - Privileged commands</p></td>
</tr>
<tr>
<td><p>ALTER DATABASE LINK</p></td>
<td><p>STANDARD ACTION</p></td>
<td><p>YES</p></td>
<td><p>E13 – Objects</p></td>
</tr>
<tr>
<td><p>ALTER PLUGGABLE DATABASE</p></td>
<td><p>STANDARD ACTION</p></td>
<td><p>YES</p></td>
<td><p>E11 - Privileged commands</p></td>
</tr>
<tr>
<td><p>ALTER PROFILE</p></td>
<td><p>STANDARD ACTION</p></td>
<td><p>YES</p></td>
<td><p>E14 - Modify configuration settings</p></td>
</tr>
<tr>
<td><p>ALTER ROLE</p></td>
<td><p>STANDARD ACTION</p></td>
<td><p>YES</p></td>
<td><p>E8 - Modify role</p></td>
</tr>
<tr>
<td><p>ALTER SYSTEM</p></td>
<td><p>SYSTEM PRIVILEGE</p></td>
<td><p>YES</p></td>
<td><p>E14 - Modify configuration settings</p></td>
</tr>
<tr>
<td><p>ALTER USER</p></td>
<td><p>STANDARD ACTION</p></td>
<td><p>YES</p></td>
<td><p>E6 - Modify user account</p></td>
</tr>
<tr>
<td><p>AUDIT SYSTEM</p></td>
<td><p>SYSTEM PRIVILEGE</p></td>
<td><p>YES</p></td>
<td><p>E11 - Privileged commands</p></td>
</tr>
<tr>
<td><p>CREATE ANY JOB</p></td>
<td><p>SYSTEM PRIVILEGE</p></td>
<td><p>YES</p></td>
<td><p>E13 – Objects</p></td>
</tr>
<tr>
<td><p>CREATE ANY LIBRARY</p></td>
<td><p>SYSTEM PRIVILEGE</p></td>
<td><p>YES</p></td>
<td><p>E13 – Objects</p></td>
</tr>
<tr>
<td><p>CREATE ANY PROCEDURE</p></td>
<td><p>SYSTEM PRIVILEGE</p></td>
<td><p>YES</p></td>
<td><p>E13 – Objects</p></td>
</tr>
<tr>
<td><p>CREATE ANY SQL TRANSLATION PROFILE</p></td>
<td><p>SYSTEM PRIVILEGE</p></td>
<td><p>YES</p></td>
<td><p>E11 - Privileged commands</p></td>
</tr>
<tr>
<td><p>CREATE ANY TABLE</p></td>
<td><p>SYSTEM PRIVILEGE</p></td>
<td><p>YES</p></td>
<td><p>E13 – Objects</p></td>
</tr>
<tr>
<td><p>CREATE DATABASE LINK</p></td>
<td><p>STANDARD ACTION</p></td>
<td><p>YES</p></td>
<td><p>E13 – Objects</p></td>
</tr>
<tr>
<td><p>CREATE DIRECTORY</p></td>
<td><p>STANDARD ACTION</p></td>
<td><p>YES</p></td>
<td><p>E13 – Objects</p></td>
</tr>
<tr>
<td><p>CREATE EXTERNAL JOB</p></td>
<td><p>SYSTEM PRIVILEGE</p></td>
<td><p>YES</p></td>
<td><p>E13 – Objects</p></td>
</tr>
<tr>
<td><p>CREATE PLUGGABLE DATABASE</p></td>
<td><p>STANDARD ACTION</p></td>
<td><p>YES</p></td>
<td><p>E11 - Privileged commands</p></td>
</tr>
<tr>
<td><p>CREATE PROFILE</p></td>
<td><p>STANDARD ACTION</p></td>
<td><p>YES</p></td>
<td><p>E11 - Privileged commands</p></td>
</tr>
<tr>
<td><p>CREATE PUBLIC SYNONYM</p></td>
<td><p>SYSTEM PRIVILEGE</p></td>
<td><p>YES</p></td>
<td><p>E13 – Objects</p></td>
</tr>
<tr>
<td><p>CREATE ROLE</p></td>
<td><p>STANDARD ACTION</p></td>
<td><p>YES</p></td>
<td><p>E7 - Create role</p></td>
</tr>
<tr>
<td><p>CREATE SQL TRANSLATION PROFILE</p></td>
<td><p>SYSTEM PRIVILEGE</p></td>
<td><p>YES</p></td>
<td><p>E13 – Objects</p></td>
</tr>
<tr>
<td><p>CREATE USER</p></td>
<td><p>SYSTEM PRIVILEGE</p></td>
<td><p>YES</p></td>
<td><p>E5 – Create user account</p></td>
</tr>
<tr>
<td><p>DROP ANY PROCEDURE</p></td>
<td><p>SYSTEM PRIVILEGE</p></td>
<td><p>YES</p></td>
<td><p>E13 – Objects</p></td>
</tr>
<tr>
<td><p>DROP ANY SQL TRANSLATION PROFILE</p></td>
<td><p>SYSTEM PRIVILEGE</p></td>
<td><p>YES</p></td>
<td><p>E13 - Objects</p></td>
</tr>
<tr>
<td><p>DROP ANY TABLE</p></td>
<td><p>SYSTEM PRIVILEGE</p></td>
<td><p>YES</p></td>
<td><p>E13 – Objects</p></td>
</tr>
<tr>
<td><p>DROP DATABASE LINK</p></td>
<td><p>STANDARD ACTION</p></td>
<td><p>YES</p></td>
<td><p>E13 – Objects</p></td>
</tr>
<tr>
<td><p>DROP DIRECTORY</p></td>
<td><p>STANDARD ACTION</p></td>
<td><p>YES</p></td>
<td><p>E13 – Objects</p></td>
</tr>
<tr>
<td><p>DROP PLUGGABLE DATABASE</p></td>
<td><p>STANDARD ACTION</p></td>
<td><p>YES</p></td>
<td><p>E11 - Privileged commands</p></td>
</tr>
<tr>
<td><p>DROP PROFILE</p></td>
<td><p>STANDARD ACTION</p></td>
<td><p>YES</p></td>
<td><p>E14 - Modify configuration settings</p></td>
</tr>
<tr>
<td><p>DROP PUBLIC SYNONYM</p></td>
<td><p>SYSTEM PRIVILEGE</p></td>
<td><p>YES</p></td>
<td><p>E13 – Objects</p></td>
</tr>
<tr>
<td><p>DROP ROLE</p></td>
<td><p>STANDARD ACTION</p></td>
<td><p>YES</p></td>
<td><p>E8 - Modify role</p></td>
</tr>
<tr>
<td><p>DROP USER</p></td>
<td><p>SYSTEM PRIVILEGE</p></td>
<td><p>YES</p></td>
<td><p>E6 - Modify user account</p></td>
</tr>
<tr>
<td><p>EXEMPT ACCESS POLICY</p></td>
<td><p>SYSTEM PRIVILEGE</p></td>
<td><p>YES</p></td>
<td><p>E14 - Modify configuration settings</p></td>
</tr>
<tr>
<td><p>EXEMPT REDACTION POLICY</p></td>
<td><p>SYSTEM PRIVILEGE</p></td>
<td><p>YES</p></td>
<td><p>E14 - Modify configuration settings</p></td>
</tr>
<tr>
<td><p>GRANT ANY OBJECT PRIVILEGE</p></td>
<td><p>SYSTEM PRIVILEGE</p></td>
<td><p>YES</p></td>
<td><p>E9 - Grant/revoke user privileges</p></td>
</tr>
<tr>
<td><p>GRANT ANY PRIVILEGE</p></td>
<td><p>SYSTEM PRIVILEGE</p></td>
<td><p>YES</p></td>
<td><p>E9 - Grant/revoke user privileges</p></td>
</tr>
<tr>
<td><p>GRANT ANY ROLE</p></td>
<td><p>SYSTEM PRIVILEGE</p></td>
<td><p>YES</p></td>
<td><p>E9 - Grant/revoke user privileges</p></td>
</tr>
<tr>
<td><p>LOGMINING</p></td>
<td><p>SYSTEM PRIVILEGE</p></td>
<td><p>YES</p></td>
<td><p>E12 - Modify audit and logging</p></td>
</tr>
<tr>
<td><p>LOGOFF</p></td>
<td><p>STANDARD ACTION</p></td>
<td><p>YES</p></td>
<td><p>E2 - Logoff</p></td>
</tr>
<tr>
<td><p>LOGON</p></td>
<td><p>STANDARD ACTION</p></td>
<td><p>YES</p></td>
<td><p>E1 - Login</p></td>
</tr>
<tr>
<td><p>PURGE DBA_RECYCLEBIN</p></td>
<td><p>SYSTEM PRIVILEGE</p></td>
<td><p>YES</p></td>
<td><p>E11 - Privileged commands</p></td>
</tr>
<tr>
<td><p>SET ROLE</p></td>
<td><p>STANDARD ACTION</p></td>
<td><p>YES</p></td>
<td><p>E11 - Privileged commands</p></td>
</tr>
<tr>
<td><p>TRANSLATE ANY SQL</p></td>
<td><p>SYSTEM PRIVILEGE</p></td>
<td><p>YES</p></td>
<td><p>E11 - Privileged commands</p></td>
</tr>
</tbody>
</table>

If you have questions, please contact us at <mailto:info@integrigy.com>

## Reference

- Integrigy Oracle 12c Unified Auditing Whitepaper [Oracle 12c Unified Auditing](https://www.integrigy.com/security-resources/oracle-12c-unified-auditing)
- Oracle Database Security Guide 12c Release 1 <http://docs.oracle.com/database/121/DBSEG/auditing.htm#DBSEG493>
- Why Mixed Mode is generating log data and how to disable it refer to “The UNIFIED_AUDIT_TRAIL is Getting Populated even if Unified Auditing was not explicitly enabled in 12c” Note ID 1624051.1, Oracle Corporation, 28 March 2014, <https://support.oracle.com/rs?type=doc&id=1624051.1>
