Re: Recording Logon and SQL

Hi

Why not just use audit session to capture the logon/logoff. To capture all SQL you can use fine grained audit and use a predicate that will be true for every access to each table and record the SQL from the trigger.

If you do not have the correct version to support FGA then use normal audit to track access but you will not get the SQL that way and will also not get selects. I think Fine grained audit is the way to go for you.

hth

kind regards

Pete

In article <N%JNa.16492$Ix2.8148_at_rwcrnsc54>, netnews.comcast.net <jglickma_at_lynx.neu.edu> writes
>Does anybody know of a way to track every user
>and SQL statement from the v$session and
>v$sqlarea without using auditing. Currently we are using
>a stored procedure that polls these tables but sometimes
>the pool is flushed allowing statements to slip in between the cracks.
>Looking for a better way of doing this.

-- 
Pete Finnigan
email:pete_at_petefinnigan.com
Web site: http://www.petefinnigan.com - Oracle security audit specialists
Book:Oracle security step-by-step Guide - see http://store.sans.org for details.