How to allow other people see my trigger source code 1

[huchen]

Hello,

I want other people see my trigger source code in Oracle.

what is the right syntax for granting this ?

Thank you very much.

 

[huchen]

I ran this:
grant select any dictionary to user1;

and it still does not work.

by the way, user1 is another developer and I have a dba role.

Thank you.

 

[SantaMufasa]

Huchen,

What data-dictionary view is "User1" accessing to see the trigger code? If you have done a "grant select any dictionary to user1;", then the following query should work for you:

select <expression-list> from dba_triggers where owner = '<trigger-owner>';

Let us know your findings.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I can provide you with low-cost, remote Database Administration services: see our website and contact me via www.dasages.com]

 

[huchen]

In order for user1 to see other people's trigger list in Toad, I have to issue this:
grant create any trigger to user1;

Thank you very much for your help. I am all set.