RE: auditing code changes ?

From: Powell, Mark D <>
Date: Thu, 25 Sep 2008 10:02:43 -0400
Message-ID: <>

I believe the command you want is AUDIT PROCEDURE. We audit DDL in production and I see all CREATE, ALTER, and DROP statements issued against pretty much all the object types I care about including procedures. I am pretty sure the commands I used were AUDIT object_type though it has been a few years since I set this up.  

  • Mark D Powell -- Phone (313) 592-5148

[] On Behalf Of Freeman, Donald

	Sent: Thursday, September 25, 2008 8:48 AM
	To: '';
	Subject: RE: auditing code changes ?
	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



[] On Behalf Of Dba DBA
Sent: Thursday, September 25, 2008 8:28 AM To: 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 ?         

Received on Thu Sep 25 2008 - 09:02:43 CDT

Original text of this message