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