Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> audit question
Hi!
It's Oracle 9.2.0.4
We set up DB level of audit and on session level:
AUDIT ALL BY username by session whenever successful; AUDIT ALL PRIVILEGES BY username by session whenever successful;
I've check some notes on MetaLink and found some information (but not =
enough).=20
Now, I'm trying to find out what my audited user did in selected period =
of time. I have list of objects on which he was working. Also, I know =
that it was DML operation. But I can't find which DML operation.
Dou you have select from which I can see which DML operation was issued = on some table, by audited user?
TIA,
Sonja
-- http://www.freelists.org/webpage/oracle-lReceived on Wed May 25 2005 - 04:58:57 CDT
![]() |
![]() |