Monitoring Object changes in Oracle
Home > IT Answers > CIO > Monitoring Object changes in Oracle
QAQA
65 pts.
0
Q:
Monitoring Object changes in Oracle
Sarbanes-Oxley Act, Oracle administration, SOX, Oracle 9i, Oracle 10g, Oracle 11i, dba_objects
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: Oct 13 2008  6:17 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
MikeR
155 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
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
Last Answered: Oct 14 2008  3:08 PM GMT by MikeR   155 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



0