cancel
Showing results for 
Search instead for 
Did you mean: 

oracle level audit

Former Member
0 Kudos

hi

I want to audit sap system at oracle level .

how can I enable auditing at oracle?

thanks

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

thankyou

former_member524429
Active Contributor
0 Kudos

Hi,

Execute this command to see your existing Oracle Audit Parameters settings.

SQL> SHOW PARAMETER AUDIT

By setting following oracle profile parameters, one can configure Audit at Oracle DB level.

audit_file_dest

audit_sys_operations

audit_trail

You can refer this [useful link|http://www.oracle-base.com/articles/10g/Auditing_10gR2.php] to get more detailed information on "How to Enable/Disable Oracle level Audit ?" "How to view the Audit records about the activities done ?" etc...etc..

You can enable Table Access level Auditing also. Please refer SAP Note 1128663 to get more info.

Regards,

Bhavik G. Shroff