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 |