Audit Packages and Procedures -- Help With dependencies
882742Aug 16 2011 — edited Aug 18 2011Hello, I would like to help on a problem I have in oracle.
well, actually we have a project where we need to perform a certain audit certain database objects to identify who was responsible for the change and the reason for the change. for that we had the idea of making the creation of a trigger event in the compilation of all objects, but at the time of the audit we face a problem of identification of the object, I know that you can identify the compiled object using the command ORA_DIST_OBJ, but I can not identify which object was the first compiled since the trigger is fired for each of the dependencies recompiled automatically by Oracle. Exemplifying.:
I have the following objects
-> Package PC_OBJECT1.PR_OBJECT_GRANDFATHER
-> Package PC_OBJECT1.PR_OBJECT_FACHER
-> Package PC_OBJECT1.PR_OBJECT_SON
-> Package PC_OBJECT1.PR_OBJETO_GRANDSON
Being the grandson of the child dependency, which is a dependency of his father, who is the grandfather dependence, I want to monitor in this situation allways when the compilation of the parent object occur , but I only want to know when the changed object and the compile occur (which the User execute the compiler command) on the parent object itself. Don't need to store information when the object is compiled because the GRANDFATHER object has been compiled and the father object as a dependency has been compiled too. Is there any way to know that!? what is the object that actually received the command of compile and that was not compiled because he was dependent!?
Sorry for the size of the message, but I tried to be as clear as possible ....
Thank you to everyone who can help!
oracle version
Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
PL/SQL Release 9.2.0.8.0 - Production
CORE 9.2.0.8.0 Production
TNS for IBM/AIX RISC System/6000: Version 9.2.0.8.0 - Production
NLSRTL Version 9.2.0.8.0 - Production