‎2012-02-14
02:46 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
ORACLE Audit logs
Hi All, I have integrated ORACLE 10g last week, logs are being received but could not find them useful. I am not getting audit logs like SELECT, DELETE, MODIFY etc..on Database. Please let me know what cnofiguratino I need to do on database to recieve some useful oracle logs. Thanks,
3 Replies
‎2012-02-14
07:44 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
Hi All, Please help in this regard.
‎2012-02-15
10:54 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
Oracle by default only audits very few events unless configured. http://docs.oracle.com/cd/B19306_01/network.102/b14266/cfgaudit.htm#i1007559
enVision-Oracle guide has some examples (p6-p7) but before configuring I suggest you to go through link:
http://docs.oracle.com/cd/B19306_01/network.102/b14266/cfgaudit.htm.
You can also read up about enabling privileged auditing here:
http://docs.oracle.com/cd/B19306_01/network.102/b14266/cfgaudit.htm#i1007245
Access based auditing fills up database pretty quickly so we often suggest DBAs to configure auditing based on their environment.
‎2012-02-16
04:33 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
Thanks for providing the information. By going through those links I could understand that auditing has to be enabled at database end. As I do not have any experience in executing those commands, I would request you to please share the procedure (commands). Thanks,
