Grant Alter Routine syntax question

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View
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';


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

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

Site Timeline