RE: auditing code changes ?

  • From: "Freeman, Donald" <dofreeman@xxxxxxxxxxx>
  • To: "'oracledbaquestions@xxxxxxxxx'" <oracledbaquestions@xxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 25 Sep 2008 08:48:13 -0400

I believe you can at least check dba_objects and see the last_compile_time.  
Won't tell you who did it though.

Donald Freeman
Database Administrator II
Commonwealth of Pennsylvania
Department of Health
Bureau of Information Technology
2150 Herr Street
Harrisburg, PA 17103
dofreeman@xxxxxxxxxxx<mailto:dofreeman@xxxxxxxxxxx>



________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Dba DBA
Sent: Thursday, September 25, 2008 8:28 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: auditing code changes ?

I have auditing turned on. It does not appear to track when someone recompiles 
code.

I have audit all on.

is there a way to track this ?

Other related posts: