If I defined I stored procedure as root I can't be able to call this procedure from a normal user. I tried to grant it the execute method but the sintax seems wrong
For example suppose a simple store procedure like this: CREATE PROCEDURE `test_root`() BEGIN declare a int default 0; END if I try to grant the execute permission to other users I got an error like this: mysql> grant execute on test_root to '%'@localhost; ERROR 1144 (42000): Illegal GRANT/REVOKE command; please consult the manual to s ee which privileges can be used The only way to get stored procedure working is to create it as normal users, but this is not a polite way. Someone can help ? Regards, Enzo [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
