I solve the problem, and I report it in case this should be usefull to someone else. Simply the manual reported a wrong sintax. To grant on privilege on a tored procedure or a function the command should be: mysql> grant execute on function test_function to '%'@localhost; mysql> grant execute on procedure test_procedure to '%'@localhost;
-----Messaggio originale----- Da: AESYS S.p.A. [Enzo Arlati] [mailto:[EMAIL PROTECTED] Inviato: venerdì 18 novembre 2005 14.37 A: mysql@lists.mysql.com Oggetto: setup permission for stored procedure on mysql 5 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
