Re: How to audit records of certain table

From: joachim Carlsson <IKEA-joachim.carlsson_at_neurope.ikea.com>
Date: Mon, 4 May 1998 13:49:55 +0200
Message-ID: <6ika87$ub$1@mailgate.ikea.com>

The audit function is not very usefull (unfortunately) for this kind of informationhunting.

What you need to do is to write a databasetrigger that writes the updated records to a spoolfile when necessary.

Regards
/Joachim

Sim Keng Hwee wrote in message <354D7F88.4F17F63C_at_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 - 06:49:55 CDT