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!

grant execute on schema.pakage.procedure.........

malhiMay 9 2011 — edited May 9 2011
i need to grant execute permission to a user on a procedure that is part of a package, i give this command which return error. What should i do
 grant execute on  CORE_BUSINESS.PKG_CORE_BUSINESS_IP.ALTER_TEMP_INSURED_PERSON_DATA to cb_softdata;
[Error] Execution (3: 53): ORA-00905: missing keyword
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 6 2011
Added on May 9 2011
4 comments
1,520 views