If you look at the source of the ALL_TRIGGERS view (at least in 8i), you'll see that the CREATE ANY TRIGGER priv is needed for a schema to see triggers of another schema. Since this probably isn't what you want, you have some options:
1) GRANT SELECT ON DBA_TRIGGERS TO your_schema; 2) Reverse engineer the ALL_TRIGGERS view, removing the restriction and calling it something else like OUR_TRIGGERS. Put this view in a non-SYS/non-SYSTEM DBA schema of yours and GRANT SELECT where necessary. 3) Modify the ALL_TRIGGERS view directly, removing the restriction and waiting for the appropriate rant from Mladen about not modifying the data dictionary. And I'd agree with him -- don't do this. Enjoy! Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA > -----Original Message----- > From: IT - Database (Do Not Use) > [mailto:[EMAIL PROTECTED] > Sent: Thursday, July 31, 2003 2:59 PM > To: Multiple recipients of list ORACLE-L > Subject: Viewing the trigger source code > > > My brain is not working today....I cannot figure out how to > allow one user > to look at the source code (i.e. trigger_body) for a trigger owned by > another user. The fact that there is an all_triggers view leads me to > believe that it must be possible....but I can't figure out > how to do it and > I have RTFM and I can't find any references there either. > Can anyone help > me out? > > TIA > Debbie -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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).