Solved

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

Posted on 2011-02-14
3
1,930 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
3 Comments
 
LVL 21

Expert Comment

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

Accepted Solution

by:
simonpaul64 earned 500 total points
Comment Utility
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
Comment Utility
Thanks, I missed the 'function' keyword!
0

Featured Post

Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

Join & Write a Comment

Introduction In this installment of my SQL tidbits, I will be looking at parsing Extensible Markup Language (XML) directly passed as string parameters to MySQL 5.1.5 or higher. These would be instances where LOAD_FILE (http://dev.mysql.com/doc/refm…
This guide whil teach how to setup live replication (database mirroring) on 2 servers for backup or other purposes. In our example situation we have this network schema (see atachment). We need to replicate EVERY executed SQL query on server 1 to…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

762 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

Need Help in Real-Time?

Connect with top rated Experts

7 Experts available now in Live!

Get 1:1 Help Now