Re: Auditing the selection SQL issuing by users in Oracle 8i

From: Mark Townsend <markbtownsend_at_home.com>
Date: Tue, 24 Jul 2001 20:54:26 GMT
Message-ID: <B7832E93.C1D6%markbtownsend@home.com>

in article 178d2795.0107241218.2349687d_at_posting.google.com, Mark D Powell at mark.powell_at_eds.com wrote on 7/24/01 1:18 PM:

> Joe Kazimierczyk <joseph.kazimierczyk_at_bms.com> wrote in message
> news:<3B5D59CC.FA17273B_at_bms.com>...

>> You can AUDIT SELECT ON tablename; for every object you are
>> interested in.  Or AUDIT SELECT TABLE; to audit selects on
>> all objects.   This can generate a large audit trail, so
>> watch out!  And it only tells you that a certain user did a
>> select on a certain object.  You don't see what the actual
>> select was.
>> 
>> RLC wrote:
>>> 
>>> I would like to know is there any possible solution to record every
>>> selection SQL commands issuing by users in Oracle 8i ??

>
> Richard, Joe gave you one way. If you mean all SQL and not just
> selects you can turn tracing on either at the database level (all
> users, lots of trace files), at the session level using alter session
> set sql_trace=true to trace what you are going to do, and for a
> running session (see dbms_system) if you want a record of what SQL an
> existing session is issuing but you will miss what was done prior to
> your starting the trace. See Oracle 8i Reference manual for the
> init.ora parameter sql_trace.
>
> -- Mark D Powell --

Also look at fine grained auditing - an Oracle9i feature, but if you need it, a good reason to go to 9i - see
http://download-west.oracle.com/otndoc/oracle9i/901_doc/appdev.901/a88876/ad gsec02.htm#1006527 Received on Tue Jul 24 2001 - 15:54:26 CDT