Database Administration (MOSC)

MOSC Banner

Audit Trail 11g XML tag <Client_ID> empty

edited Mar 25, 2019 5:06AM in Database Administration (MOSC) 5 commentsAnswered

Hi,

i have wierd problem with field "CLIENT_ID" as when we've had audit trail set to DB we got this field populated by application user (as it should be) name however after switching over to XML this tag is missing from XML audit log files. Both V$Session and (ex) db_audit_trail table have this field populated so it should be working application/oracle wise.  Ofcourse view V_$XML_AUDIT_TRAIL has this field "null".

I don't have any special auditing policies setup everything is by default as our primary auditing tool is IBM Guardium and this application tag works. I'm exploring options of removing IBM tool and use Oracle natives auditing but so far this issue is kind of killing this option as we really need appuser to be audited.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center