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 -> How to audit records of certain table

How to audit records of certain table

From: Sim Keng Hwee <simkh_at_ses.st.com.sg>
Date: Mon, 04 May 1998 16:42:48 +0800
Message-ID: <354D7F88.4F17F63C@ses.st.com.sg> 





Hi, I need help. Database object audit can audit table, view etc. The
user_audit_object does not show which  records are being queried,
inserted, updated or deleted. For example if a user performs the
following query : "select * from emp where id =3;" How can I know the
user querid on what record. This info is not captured in the audit
trail. Can I perform audit on record or records of certain table.  Hope
to hear from you . Thanks and Bye.

Received on Mon May 04 1998 - 03:42:48 CDT












Original text of this message













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