From: AESYS S.p.A. [Enzo Arlati] (enzo.arlatiaesys.it)
Date: Mon Nov 21 2005 - 01:29:11 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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:enzo.arlatiaesys.it]
Inviato: venerdì 18 novembre 2005 14.37
A: mysqllists.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
enzo.arlatiaesys.it

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=enzo.arlatiaesys.it

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]