Viewing objects in other schemas with limited permissions

[Sunil Varghese]

How do I view the procedure/package code in other schemas. Say, when logged on to TEST or PRODUCTION instances, where there is only limited permission to view the code.

Thanks in advance

 

[ScottMattes]

I think you need permissions.

 

[Sunil Varghese]

I have permissions to view the code, still I cannot view!

Is there any settings that I can do in PL/SQL Developer?

Thanks

 

[Sunil Varghese]

I got it!

PL/SQL Developer>Tools>Preferences>Oracle>Options

Enable "Use DBA Views if available".

This will allow you to view code in other schemas.