RE: auditing code changes ?
From: Powell, Mark D <mark.powell_at_eds.com>
Date: Thu, 25 Sep 2008 10:02:43 -0400
Message-ID: <D1DC33E67722D54A93F05F702C99E2A902EA6E92@usahm208.amer.corp.eds.com>
Date: Thu, 25 Sep 2008 10:02:43 -0400
Message-ID: <D1DC33E67722D54A93F05F702C99E2A902EA6E92@usahm208.amer.corp.eds.com>
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
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Freeman, Donald
Sent: Thursday, September 25, 2008 8:48 AM To: 'oracledbaquestions_at_gmail.com'; oracle-l_at_freelists.org Subject: RE: auditing code changes ? I believe you can at least check dba_objects and see thelast_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_at_state.pa.us ________________________________ From: oracle-l-bounce_at_freelists.orgsomeone recompiles code.
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Dba DBA
Sent: Thursday, September 25, 2008 8:28 AM To: oracle-l_at_freelists.org Subject: auditing code changes ? I have auditing turned on. It does not appear to track when
I have audit all on.
is there a way to track this ?
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Sep 25 2008 - 09:02:43 CDT