View package bodies from other schema

[phocai]

Can someone tell me if it is possible to view package bodies and triggers belonging to one schema from a different schema? We are using PL/SQL Developer 5.1.2.682 and have only been able to view package specs from the browser. Many thanks.

 

[cassiusdrow]

Make sure you have Tools> Preferences> Options Tab> "Use DBA Views if available" checked.

[This message has been edited by cassiusdrow (edited 19 May 2003).]

 

[kcharter81]

Hi, did you ever get this working? I set the option that was sent to you in reply, but I still can't see the bodies in other schemas. I'm on 5.1.3.704. Appreciate any help you can give.

Originally posted by phocai:
Can someone tell me if it is possible to view package bodies and triggers belonging to one schema from a different schema? We are using PL/SQL Developer 5.1.2.682 and have only been able to view package specs from the browser. Many thanks.

 

[rbrooker]

the way i do it is to browse through the "users" folder, expand a user, expand "objects", expand "packages", select a package, right click and select "view spec and body"

works well

of course, it helps if you are logged in as "sys"

------------------
richard.brooker@vuw.ac.nz

[This message has been edited by rbrooker (edited 25 July 2003).]

 

[phocai]

No, I never did get it to work.

 

[Marco Kalter]

You will need select privileges on the sys.dba_objects and sys.dba_source views. You also need to enable the "Use DBA views if available" preference as stated above.

This should do the trick.

------------------
Marco Kalter
Allround Automations

 

[gpoore]

i have successfully set up pl/sql so that i can view packages owned by other users, as described above) however i cannot see the triggers. Is this possible?

Originally posted by mkalter:
You will need select privileges on the sys.dba_objects and sys.dba_source views. You also need to enable the "Use DBA views if available" preference as stated above.

This should do the trick.

 

[Marco Kalter]

You'll probably need select privileges on dba_triggers (and dba_objects).

------------------
Marco Kalter
Allround Automations