How to grant "read only" privilege on Body Packages to other users
536213Jan 26 2007 — edited Jan 27 2007Hi, 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