Re: questions on audit question

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Fri, 21 Jan 2005 18:29:09 -0800
Message-ID: <41f1ba6b$1_2@127.0.0.1>

susana73_at_hotmail.com wrote:

> I want to audit any insert, update transaction on a particular table.
> So I set audit_trail=DB then "audit insert, update on db1.tablename;"
>

>>From the SYS.AUD$ table, the result only shows ONE audit record for

> each session. For example, if UserA do 2 INSERTS and 3 UPDATES on the
> table during the session, I only got ONE record in SYS.AUD$:
>
> SQL> select userid, ses$actions from user_audit_object;
> USERA ------S---S-----
>
> But I want to see the exact number of times the tables are being insert
> and update. How to accomplish that?
>
> Susan

And your Oracle version is?

Given no version number ... look at using an after insert or update trigger.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)


----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! >100,000 Newsgroups
---= East/West-Coast Server Farms - Total Privacy via Encryption =---

Received on Fri Jan 21 2005 - 20:29:09 CST