Resolution
How do I configure VigilEnt Audit Manager for Oracle to capture the PeopleSoft username (OPERID) during the auditing three-tier logins?
fact
VigilEnt Audit Manager for Oracle
fact
VigilEnt Security Agent for Oracle
fix
There are two parameters found in the PeopleSoft Application Server configuration file that should be configured to allow this information to be passed into the Oracle audit trail and ultimately to VigilEnt Audit Manager for Oracle. The parameters are EnableDBMonitoring and Log Fence. The suggested settings for these parameters would be: 'EnableDBMonitoring=1' and 'LogFence=3'.
A sample of the Application configuration file is shown below:
[Database Options]
;==============================================
; Database-specific configuration options
;==============================================
DB2InputMessageSize=
DB2OutputMessageSize=
SybasePacketSize=
; Please see Chapter "Tuning and Administration", in
; Oracle Installation and Administration Guide for details
UseLocalOracleDB=0
EnableDBMonitoring=1
;-------------------------------------------------------------------------
; Logging detail level
;
; Level Type of information
; ----- -------------------
; -100 - Suppress logging
; -1 - Protocol, memory errors
; 0 - Status information
; 1 - General errors
; 2 - Warnings
; 3 - Tracing Level 1 (default)
; 4 - Tracing Level 2
; 5 - Tracing Level 3
Log Fence=3
note
Please reference the PeopleSoft documentation for more information.