Grant Alter Routine syntax question
am 14.05.2006 20:53:32 von everymnHi,
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