Skip to Main Content

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 any function or package

A-KMay 23 2009 — edited May 23 2009
Hi,

Does the below command give execute priviliges on functions and packages too ?

grant execute any procedure to <user>;


When i give same for fucntion it gives following error,
SQL> grant execute any function to user2;
grant execute any function to user2
*
ERROR at line 1:
ORA-00990: missing or invalid privilege


Thanks.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 20 2009
Added on May 23 2009
2 comments
31,282 views