RE: auditing code changes ?
- From: "Powell, Mark D" <mark.powell@xxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 25 Sep 2008 10:02:43 -0400
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Freeman, Donald
Sent: Thursday, September 25, 2008 8:48 AM
To: 'oracledbaquestions@xxxxxxxxx'; oracle-l@xxxxxxxxxxxxx
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
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:
