Posted By: Babo {bug} unable to see other user's procs/funcs - 11/02/07 08:52 PM
seems like a bug to me.
create user a ...
grant create session to a
grant select_catalog_role to a ;
grant debug any procedure to a ;
grant select any dictionary to a ;
grant select any table to a ;

this should give me not only read access to other user's tables/indexes , but procs and functions.
For some reason it doesn't.
latest pl/sql developer.
thank you.
Maybe you need to enable the "Use DBA views if available" option (Tools > Preferences > Oracle / Options).
that fixed the problem.
thank you, Marco.
© Allround Automations forums