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!

Privilege to view package body

450238Sep 6 2005 — edited Oct 15 2010

Hi all,
I have two users... user 'A' and user 'B' (real user names changed to protect the innocent). User A creates a package spec and package body.

I want user B to be able to see the code in the package body that user A owns. Ideally I would like user B to be able to view the body code in TOAD via the schema browser or via a DESC. Is this possible?

Thanks,
Scott

PS user B can see the package spec just fine...

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 12 2010

Added on Sep 6 2005

#dba, #general-database-discussions

12 comments

156,508 views