Solved

Getting ERROR 1144 (42000) when granting execute to a user

Posted on 2011-02-14
3
2,203 Views
Last Modified: 2012-05-11
Hi Experts,

I am trying to exucute the following command to grant execute privs for a procedure.

GRANT EXECUTE ON mydb.UPDATE_LINE_ITEMS TO 'myuser'@'%';

However, I get the following error:

ERROR 1144 (42000): Illegal GRANT/REVOKE command; please consult the manual to see which privileges can be used


What am I doing wrong?

Thanks
0
Comment
Question by:jagku
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 21

Expert Comment

by:theGhost_k8
ID: 34887244
Try: GRANT EXECUTE ON mydb.* TO 'myuser'@'%';
0
 
LVL 5

Accepted Solution

by:
simonpaul64 earned 500 total points
ID: 34887273
Execute is not implemented until MySQL 5.0.3

After that version you should be able to do this:-

GRANT EXECUTE ON  function mydb.UPDATE_LINE_ITEMS TO 'myuser'@'%';
0
 

Author Closing Comment

by:jagku
ID: 34887321
Thanks, I missed the 'function' keyword!
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Foreword In the years since this article was written, numerous hacking attacks have targeted password-protected web sites.  The storage of client passwords has become a subject of much discussion, some of it useful and some of it misguided.  Of cou…
Popularity Can Be Measured Sometimes we deal with questions of popularity, and we need a way to collect opinions from our clients.  This article shows a simple teaching example of how we might elect a favorite color by letting our clients vote for …

732 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question