Solved

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

Posted on 2011-02-14
3
2,114 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
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

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Fore-Foreword Today (2016) Maxmind has a new approach to the distribution of its data sets.  This article may be obsolete.  Instead of using the examples here, have a look at the MaxMind API (https://www.maxmind.com/en/geolite2-developer-package). …
Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL (http://www.experts-exchange.com/articles/201/Handling-Date-and-Time-in-PHP-and-MySQL.html) several years ago, it seemed like now was a good time to updat…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

808 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