i am trying to solve a problem i am facing with the possibility of viewing a package body.
I have a user A which has a package and a user B who wants to view the package body of the package owned by user A.
I have executed the
Grant execute on A.PACKAGE_NAME to B
Grant debug on A.PACKAGE_NAME to B.
User B has no other privilege in the system except for the CONNECT privilige.
If i log into the database as user B with Toad for Oracle i can view the Package Body with no problem, with just these two privileges granted.
If i log into the DB with Sql Navigator 5.5 i can view the Package Body in the DB Navigator.I just installed the Version 6.2 and the problem persists.
I have tried checking the Enable DBA views on the session , but it still doesn’t work.
Please help me.
How can i work this out using SQL Navigator because developers are like using SQL Navigator.