Re: questions on audit question

<susana73_at_hotmail.com> a écrit dans le message de news:1106357829.975037.291460_at_c13g2000cwb.googlegroups.com...
| 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
|

"audit ... BY ACCESS" (default is by session) and analyze the audit trail. or if you want only the number of inserts and updates: alter table ... monitoring;
select inserts, updates from user_tab_modifications where table_name='...';

Regards
Michel Cadot Received on Sat Jan 22 2005 - 00:41:25 CST