How Do You Audit Activity from MSACCESS.EXE Users?
I have need to audit individuals accessing a database via the program msaccess.exe. I can see their connections via Oracle Enterprise Manager Console. I would like to capture sql statements and resource usage over time so that I can identify the heavy hitters. I already do some auditing (audit_trail=db), but I would like to be able to identify any msaccess.exe activity. Is this doable? Is there a Metalink document explaining how to do this?
I am puzzled because I do not see a column for capturing program under sys.aud$, however I so see that column under v$session and v$process.
0