Skip to Main Content
Forums

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Privileges to see a package body

JustinCaveMar 3 2006 — edited Sep 19 2007
Using SQL Developer 1.0.0.14.22 on Windows XP Pro to connect to a 9.2.0.6 database

What privilege(s) do I need to be granted in order to be able to view the code in a package without having EXECUTE access to that package? With other GUIs (Enterprise Manager, TOAD, SQL Programmer, etc), SELECT ANY DICTIONARY and/or SELECT_CATALOG_ROLE seem to be sufficient. SQL Developer, though, seems to need something else. Any ideas on what privilege I need to request?

Justin
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 17 2007
Added on Mar 3 2006
#sql-developer
5 comments
3,506 views