What Is Oracle 12 Unified Auditing? The View UNIFIED_AUDIT_TRAIL with 94 Columns
What is Oracle 12c Unified Auditing? The short answer is the view UNIFED_AUDIT_TRAIL. This view consolidates all logging and auditing information into a single source. Regardless of using either Mixed Mode or Pure Unified Auditing, the SYS.UNIFIED_AUDIT_TRAIL can be used.
The key column in SYS.UNIFIED_AUDIT_TRAIL is AUDIT_TYPE. This column shows from which Oracle component the log data originated -
|
SYS.UNIFIED_AUDIT_TRAIL Component Sources |
||
|---|---|---|
|
Column AUDIT_TYPE Value |
Description |
Number of Columns in Table |
|
Standard |
Standard auditing including SYS audit records |
44 |
|
XS |
Real Application Security (RAS)and RAS auditing |
17 |
|
Label Security |
Oracle Label Security |
14 |
|
Datapump |
Oracle Data Pump |
2 |
|
FineGrainedAudit |
Fine grained audit(FGA) |
1 |
|
Database Vault |
Data Vault(DV) |
10 |
|
RMAN_AUDIT |
Oracle RMAN |
5 |
|
Direct path API |
SQL*Loader Direct Load |
1 |
|
|
Total |
94 |
If you have questions, please contact us at mailto:info@integrigy.com
Reference
- Integrigy Oracle 12c Unified Auditing Whitepaper Oracle 12c Unified Auditing
- For a full description of each column in the view see the Oracle Database Reference 12c Release 1 (12.1) http://docs.oracle.com/database/121/REFRN/refrn29162.htm#REFRN29162
