Skip to Main Content
Forums

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!

Grant EXECUTE on a PACKAGE to another PACKAGE (Not User)

993030Apr 8 2013 — edited Apr 8 2013
Hi,

I have a Package pkg1 in APPS Schema. I want to grant EXECUTE privilage on pkg1 to another package pkg2 which is in another schema xxx. However I dont want to
GRANT EXECUTE ON pkg1 TO xxx.

I tried
1) GRANT EXECUTE ON pkg1 TO xxx.pkg2
2) GRANT EXECUTE ON pkg1 TO PACKAGE xxx.pkg2 Both of them failed.


Is this possible in Oracle 11G?

Thanks & Regards
Biju Radhakrishnan
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 6 2013
Added on Apr 8 2013
#general-database-discussions
5 comments
802 views