Monitoring Object changes in Oracle

65 pts.
Tags:
dba_objects
Oracle 10g
Oracle 11i
Oracle 9i
Oracle administration
Sarbanes-Oxley Act
SOX
I have to find out who modified objects in dba_objects each week for those changed during that week for SOX perspective. Right now i check with deveplopers for each one, which they don't like. I question is how to find out who modified an object in 9i or 10g (and 11i)?
ASKED: October 13, 2008  6:17 PM
UPDATED: April 7, 2010  11:43 AM

Answer Wiki

Thanks. We'll let you know when a new response is added.

use the LAST_DDL_TIME find changes

select * from dba_objects where LAST_DDL_TIME > SYSDATE – 7

but this will not tell you who altered it

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following