I am trying to do something similar. I want to trap when new tables and procedures are created so I can issue grants and synonyms. I found in the manual triggers at the schema level but I haven't been able to make them work.
>From the manual >>>>>> CREATE OR REPLACE TRIGGER On_DDL after DDL ON XYZ.Schema BEGIN ....... <<<<<<< If anyone has an example of using this type of trigger, I would appreciate some help. I am using 8.1.6.3 and the above is taken from the 8.1.6 manual. Thanks, John >>> [EMAIL PROTECTED] 04/03/02 01:33PM >>> Hi List, I want to create a trigger that insert into a table anytime a user change or compile a package doesn't matter who create it or compile it. Is there a trigger at DB level, like the on logon, that I can create to keep this kind of control. I did some FM but couldn't find nothing. TIA Ramon E. Estevez -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Carlson INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).