ORACLE Audit logs

[RSAAdmin]

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,

[RSAAdmin]

Hi All, Please help in this regard.

[RSAAdmin]

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.

[RSAAdmin]

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,