Oracle Audit (SQL) log format and field mapping

Prev Next

Log format

The expected format for this device is:

AUDIT_TYPE="" SESSION_ID="" PROXY_SESSIONID="" STATEMENTID="" ENTRYID="" EXTENDED_TIMESTAMP=""
GLOBAL_UID="" DB_USER=" " CLIENT_ID="" ECONTEXT_ID="" EXT_NAME="" OS_USER="" USERHOST="" OS_PROCESS=""
TERMINAL="" INSTANCE_NUMBER="" OBJECT_SCHEMA="" OBJECT_NAME="" POLICY_NAME="" NEW_OWNER="" NEW_NAME=""
ACTION="" STATEMENT_TYPE="" AUDIT_OPTION="" TRANSACTIONID="" RETURNCODE="" SCN="" COMMENT_TEXT=""
SQL_BIND="" SQL_TEXT="" OBJ_PRIVILEGE="" SYS_PRIVILEGE="" ADMIN_OPTION="" OS_PRIVILEGE="" GRANTEE=""
PRIV_USED="" SES_ACTIONS="" LOGOFF_TIME="" LOGOFF_LREAD="" LOGOFF_PREAD="" LOGOFF_LWRITE=""
LOGOFF_DLOCK="" SESSION_CPU="" OBJ_EDITION_NAME="" DBID="”

Log sample

This is a sample log from an Oracle Audit device:

AUDIT_TYPE="Standard Audit" SESSION_ID="1" PROXY_SESSIONID="0" STATEMENTID="1" ENTRYID="1"
EXTENDED_TIMESTAMP="2015-01-01 00:00:00.000" GLOBAL_UID="" DB_USER="QA" CLIENT_ID="" ECONTEXT_ID=""
EXT_NAME="" OS_USER="root" USERHOST="exampleUser" OS_PROCESS="1000:1000" TERMINAL="unknown" 
INSTANCE_NUMBER="0" OBJECT_SCHEMA="" OBJECT_NAME="" POLICY_NAME="" NEW_OWNER="" NEW_NAME="" ACTION="100"
STATEMENT_TYPE="LOGON" AUDIT_OPTION="" TRANSACTIONID="0013000D00AAFF2" RETURNCODE="0" SCN="0"
COMMENT_TEXT="Authenticated by: DATABASE; Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=192.0.2.1)
(PORT=37063))" SQL_BIND="" SQL_TEXT="" OBJ_PRIVILEGE="" SYS_PRIVILEGE="" ADMIN_OPTION=""
OS_PRIVILEGE="NONE" GRANTEE="" PRIV_USED="CREATE SESSION" SES_ACTIONS="" LOGOFF_TIME="" LOGOFF_LREAD="0"
LOGOFF_PREAD="0" LOGOFF_LWRITE="0" LOGOFF_DLOCK="" SESSION_CPU="0" OBJ_EDITION_NAME="" DBID="1234567890"

This is a sample log from an Oracle Unified Audit device

AUDIT_TYPE="Standard Audit" SESSION_ID="1" PROXY_SESSIONID="0" STATEMENTID="1" ENTRYID="1"
EXTENDED_TIMESTAMP="2015-01-01 00:00:00.000" ACTION_NAME "ALTER USER" GLOBAL_UID=""
CLIENT_PROGRAM_NAME="sqlplus@hostname" DB_USER="TESTUSER" CLIENT_ID="" EXT_NAME="" OS_USER="root"
USERHOST="exampleUser" OS_PROCESS="1000:1000" TERMINAL="unknown" DBID="1234567890"
AUTHENTICATION_TYPE="(TYPE=(OS));(CLIENT ADDRESS=((ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=54526))))"
INSTANCE_NUMBER="0" OBJECT_SCHEMA="" OBJECT_NAME="" POLICY_NAME="" NEW_NAME="" AUDIT_OPTION=""
TRANSACTIONID="0013000D00AAFF2" RETURNCODE="0" SCN="0" COMMENT_TEXT="Text comment on the audit trail entry, 
if any" SQL_BIND="" SQL_TEXT="SELECT SYS_CONTEXT(‘USERENV‘,‘CDB_NAME‘), SYS_CONTEXT(‘USERENV‘,
‘CON_NAME‘) FROM SYS.DUAL" OBJ_PRIVILEGE="" SYS_PRIVILEGE="" ADMIN_OPTION="" PRIV_USED="CREATE SESSION" 
UNIFIED_AUDIT_POLICIES="ORA_SECURECONFIG, ORA_SECURECONFIG"

Field mapping for DBA_COMMON_AUDIT_TRAIL

This table shows the mapping between the data source and Trellix ESM fields.

Log fields

Trellix ESM fields

RETURNCODE

Action, Return_Code

AUDIT_TYPE

Category

DBID

Database_ID

OS_USER

Destination User

EXTENDED_TIMESTAMP

First Time, Last Time

USERHOST

Host

STATEMENT_TYPE

Action, Rule Message

OBJECT_NAME

Object

POLICY NAME

Policy Name

COMMENT_TEXT

Protocol, Source IP, Source Port

SQL_TEXT

SQL_Statement

SESSION_ID

Session_ID

ACTION

SID

DB_USER

Source User

Field mapping for UNIFIED_AUDIT_TRAIL

This table shows the mapping between the data source and Trellix ESM fields.

Log fields

Trellix ESM fields

RETURN_CODE

Action, Return_Code

AUDIT_TYPE

Category

DBID

Database_ID

OS_USERNAME

Destination User

EVENT_TIMESTAMP

First Time, Last Time

USERHOST

Host

ADDITIONAL_INFO

Message_Text

OBJECT_NAME

Object

OBJECT_SCHEMA

Database_Name

AUTHENTICATION_TYPE

Protocol, Source IP, Source Port

FGA_POLICY_NAME

Policy_Name

SESSIONID

Session_ID

ACTION_NAME

SQL_Command, sid

CLIENT_PROGRAM_NAME

Application

Log fields

Trellix ESM fields

UNIFIED_AUDIT_POLICIES

Rule_Name

DBUSERNAME

Source User

SQL_TEXT

SQL_Statement

SYSTEM_PRIVILEGE_USED

Command