Skip to Main Content

SQL & PL/SQL

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 execute access to a package body to another user

user275751Apr 19 2012 — edited Apr 19 2012
Hello

I have a package body which contains one procedure and the owner of this package APPS.

I have a requirement to grant execute access to this procedure whcih is inside the package to the user 'XXX' so that I can execute this procdure from XXX user.

When I tried below statement then it grant access to package spec not to the body. Please let me know how to give execute access to package body?
grant execute on KEI_TEK_IB_INTF_PKG to XXX;

Thanks!
This post has been answered by Srini Chavali-Oracle on Apr 19 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 17 2012
Added on Apr 19 2012
7 comments
4,806 views