Skip to Main Content

Oracle Database Discussions

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!

How to grant "read only" privilege on Body Packages to other users

536213Jan 26 2007 — edited Jan 27 2007
Hi, I want to grant read only access on body packages to development users. Those packages belong to another user that don't belong to this development group.

Developers shouldn't be able to execute or compile those packages but they need to read their body code in order to understand some application functionality. I know that if I grant them (as a DBA) the SELECT ANY DICTIONARY system privilege they will be able to do it, but they will also have access to system views and other users' objects. Do you know a more restrictive way of granting read only access to those packages?

Thanks and regards,

Leandro
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 24 2007
Added on Jan 26 2007
6 comments
5,120 views