Re: auditing code changes ?

Have a look at a paper I wrote for oaug for soxed in dbas. I used a ddl trigger to capture all ddls and details of who is changing them including os user, client, etc.

John

On 9/25/08, Powell, Mark D <mark.powell_at_eds.com> wrote:
> 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 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_at_state.pa.us
>
>
>
> ________________________________
>
> From: oracle-l-bounce_at_freelists.org
> [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
> someone recompiles code.
>
> I have audit all on.
>
> is there a way to track this ?
>
>
>

-- 
Sent from Gmail for mobile | mobile.google.com

John Kanagaraj <><
http://www.linkedin.com/in/johnkanagaraj
http://jkanagaraj.wordpress.com (Sorry - not an Oracle blog!)
** The opinions and facts contained in this message are entirely mine
and do not reflect those of my employer or customers **
--
http://www.freelists.org/webpage/oracle-l