Link to home
Get AccessLog in
Avatar of jagku
jagkuFlag for United States of America

asked on

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

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
Avatar of theGhost_k8
theGhost_k8
Flag of India image

Try: GRANT EXECUTE ON mydb.* TO 'myuser'@'%';
ASKER CERTIFIED SOLUTION
Avatar of simonpaul64
simonpaul64

Link to home
membership
This content is only available to members.
To access this content, you must be a member of Experts Exchange.
Get Access
Avatar of jagku

ASKER

Thanks, I missed the 'function' keyword!