| parveez |
Posted: Aug 31, 2007 11:51:24 AM |
Total Post: 20
Joined: Aug, 2007
|
| I want to check how many inserts or updates or deletes have been done by a user on a particular day.The datas should get stored in a table.This will help me to check how many datas are inserted by data entry operators.Kindly give a detailed procedure.I know i have to make a trigger.Please help me. |
|
|
 Mohammed Taj |
| Posted: Sep 01, 2007 12:53:44 AM |  |
|
Total Post: 704
Joined: Jul, 2007
|
Hi,
Don't use trigger...go with AUDIT options.
http://dbataj.blogspot.com/search/label/Audit%20Database
Regards
Taj
|
|
|
|
|
| parveez |
| Posted: Sep 12, 2007 01:48:56 PM | |
|
Total Post: 20
Joined: Aug, 2007
|
I did audit. But when i query the aud$ view and see the action number i get only 103 as the result instead of 3 which is for insert. Why is this happening.
|
|
|
|
|
| abhang |
| Posted: Sep 20, 2007 06:15:53 AM | |
|
Total Post: 1
Joined: Sep, 2007
|
hi,
first check wheather you have set auditing at OS or DB level.
Then check there is one AUDIT_ACTIONS table which u have to join with
your SYS.AUD$ table then u will easily get which operation is performed
by ur database user.
and if u think that u want to know which rows are inserted or updated
or deleted then perform FINE-GRAINED AUDITING.
REGARDS,
SUDHAKAR
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
