Database Security Products (MOSC)

MOSC Banner

oracle auditing

edited Jul 12, 2014 5:00AM in Database Security Products (MOSC) 1 commentAnswered

Hello Everyone,

       I have a simple task to capture ddl changes in our production db's done by users as part of internal audit report.

       Currently our production db's are on Oracle 10.2.0.4 RAC with 2 nodes on RHEL 5 Linux 64 bit servers.

       The Oracle auditing is not enabled on the databases.

       How can I capture the ddl changes in production db's by enabling Oracle Auditing.

       The report should look something like this:

login_nameServerInstanceschemaobjectstatementaction_desc
ScottServer_node1prod1HRupdate_salaryALTER PROCEDURE HR.update_salaryALTER PROC

       After going through the documentation, I am concerned about the performance overhead due to auditing on prod db's.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center