Database Security Products (MOSC)

MOSC Banner

How Do You Audit Activity from MSACCESS.EXE Users?

edited Oct 7, 2009 11:05PM in Database Security Products (MOSC) 4 commentsAnswered
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.

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