Grant Alter Routine syntax question

Grant Alter Routine syntax question

am 14.05.2006 20:53:32 von everymn

Hi,
Supposedly the Alter Routine privilege can be granted at the level of
a single routine but I haven't been able to get that to work. I've
tried it a number of different ways like:

GRANT ALTER ROUTINE ON test.'routine-name' TO
'alt-routine'@'localhost' IDENTIFIED BY 'alt-routine';

and

GRANT ALTER ROUTINE ON test.'routine-name()' TO
'alt-routine'@'localhost' IDENTIFIED BY 'alt-routine';

with the name of an existing SProc substituted for routine-name.

Eash results in error - Illegal GRANT/REVOKE command;

Anybody know what the expected syntax is?
Thank You

Re: Grant Alter Routine syntax question

am 14.05.2006 22:02:35 von every

I found the answer to this thanks. You have to include the object
type after ON [ procedure | function ]