access to package bodies outside schema

[waxwing]

I've seen a number of posts stating that for a user to be able to view the source of a package body owned by another schema, they must have select privs on dba_objects and dba_views. Our dba has been prevented from giving our development schema select privs on these data dictionary views because the dev schema does not have the dba_role. Is there a way around this problem, short of making our development schama a member of dba_role?
Thanks,
Ron Righter
Info Technology
University of Montana

 

[Gustavo]

Could you be granted the "SELECT ANY DICTIONARY" system privilege?

 

[elham]

I also have same problem. The user has "select any dictionary" role but unless I provide the user with either "alter,create or drop any procedure" privilege! I want the users to view the package body but not being able to change it!

 

[Marco Kalter]

Another user's package/type bodies will be visible if you have select privileges on the sys.dba_objects and sys.dba_source views. The "Use DBA views if available" preference (Tools > Preferences > Options tab page) also needs to be enabled though.

 

[elham]

Thanks Marco, I was missing the "Use DBA Views if available" option!