Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Audit
Hi ,
I am trying to do auditing on the DB for the first time.
I want to find couple of things but no luck.
Column STATEMENT on AUD$, didn give me the meaningful value, where can I
find the table for all the listings.
I am finding the meaningful values in DBA_AUDIT_TRAIL view.
When I do AUDIT DELETE ANY TABLE BY SCOTT; and deleting records from the
table,
I am getting values as follows.
SCOTT SESSION REC 29.09.2005 11:42:24 0 TEMP 208
But I wanna see that deletion occured , I mean anything like ROWS DELETED
or like that, possible?
Cause if I enable insert,update,delete all three, how will be I
differentiate this value SESSION REC?
Regards - Chirag
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Sep 29 2005 - 10:50:52 CDT
![]() |
![]() |