Re: How to audit records of certain table

From: Dean Mah <dmah_at_acs.ucalgary.ca>
Date: Mon, 04 May 1998 08:36:54 -0600
Message-ID: <6ikjqv$qc8@ds2.acs.ucalgary.ca>

You will need to use a trigger to capture data information. Check out Auditing Through Database Triggers in the Server Administrator's Guide.

Dean

Sim Keng Hwee wrote:

> 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 - 09:36:54 CDT