Re: VIEW DEFINTION permission

[Orlando Colamatteo]

Thank you for your response. Unfortunately I could not resolve this with GRANT SELECT. My user already has SELECT privileges on *.

Here is what my user has when I run SHOW GRANTS:

GRANT USAGE ON *.* TO 'my_user'@'192.168.%' IDENTIFIED BY PASSWORD '*66C036013C9D8DC9BD64D747243A9D2B52F1B275';
GRANT SELECT ON `my_db`.* TO 'my_user'@'192.168.%';

I also tried the following thinking that "SELECT on my_db.*" might only pertain to tables but to no avail, these produce syntax errors:

GRANT SELECT ON my_db.my_procedure TO 'my_user'@'192.168.%';
GRANT SELECT ON PROCEDURE my_db.my_procedure TO 'my_user'@'192.168.%';

What exactly did you mean by "grant 'SELECT' privilege to view stored procedure definitions"?