See body of a package that belongs to another schema
Hello,
I'm facing the following issue: We have 2 schemas - apps (oracle aaplications master schema, with dba role) and a custom schema, to which our development team connects.
We use pl/sql developer v. 7.1.5 and DB 10gR2.
When I connect to the custom schema and try to "see spec&body" of a package that belongs to apps I can see only it's spec.
(From apps I can see spec&body of the custom schema).
I searched in the internet and in the forum, but couldn't find a solution that work. Does someone know what privilages/roles can I give to the custom schema to see the body? (I can't give it strong privilages in the production enviornment).
It already has 'debug any procedure' , 'debug any session' , 'select any table' and I tried to give it 'execute any libarary' and 'execute any program'