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

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 --