View Packages Only select catalog role
557025Jan 18 2007 — edited Jan 26 2007We have a user who can not have execute privledges on packages, but does need to see them. We granted him select catalog role, and he can hit the catalog tables. But when he logs into sql developer he can not view the packages or procedures even though he has correct db permissions. Similar issue w/ Toad, where you can have toad check for access to DBA views. Do not see a similar functionality here. Anybody else run into this issue? Thanks!!!