How to audit Program Name when using DB Audit Trail?
fuzzydbaJan 28 2009 — edited Jan 28 2009Hi All,
I am working on a Oracle 10g R2 database. I tried to enable Database Auditing (SQL> ALTER SYSTEM SET audit_trail=db SCOPE=SPFILE;). Now, every thing works fine, but the only problem is that the audit trail functionality that oracle uses doesn't log which program the user (client) used to connect to the database. There's a column called "Program" in the V$SESSION view that can be used to capture the "Program Name" but that can be done via a Trigger only. Now, the only reason that i went to use Audit_trail was that i didn't want to use a trigger (just 'cuz i wanted to experiment with the built-in functionality)
Is there a way to pull out the "Program Name" without the use of trigger? Or, is it already in some Audit_trail view which i haven't found out yet?
Regards,
FuzzyDBA