Browsing objects from others users

[Cesare Rossi]

Hi,

Somebody knows if the only way that i can browse the objects from the others user in PL/SQL Developer, is if i have grant to execute this object ?
I have an user that's need only to "see" the object code, without change it or compile it and it is not possible, for while, to do it in PL/SQL Developer. In Sql Developer, i can browse this objects, apparently, without any grant from this. Could it's be possible to get the same results without grants to compile?

 

[Marco Kalter]

If you have select privileges on the sys.dba_objects view and enable the "Use DBA views if available" option (Tools > Preferences > Oracle / Options) then you can browse objects owned by other users without explicit object privileges.