Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: How to trace user performing a query?

Re: How to trace user performing a query?

From: Iosif Tanasescu <a_at_j.smith>
Date: 21 Apr 1998 23:32:35 GMT
Message-ID: <01bd6d7d$cf3330a0$a51c67d1@iosif> 





audit select on owner.table whenever ..;
and don't forget audit_trail=true ( in initxxxx.ora)



Sim Keng Hwee <simkh_at_usa.net> wrote in article
<353C4238.F3A3E57B_at_usa.net>...


> In Database Trigger, it can only trace Update, Delete and Insert


> action.  What if I want to trace user performing query? Could it be


> done? If yes, how it can be done? Please advice. Thank you.


> 


> 


Received on Tue Apr 21 1998 - 18:32:35 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US