mysql / show procedure / grant
How to I grant myself permissions to show MySQL FUNCTION and
PROCEDURE bodies?
It isn’t this:
mysql> grant all privileges on procedure *.* to walter;
ERROR 1144 (42000): Illegal GRANT/REVOKE command; please consult the manual to see which privileges can be used
But it is this:
mysql> grant select on mysql.proc to walter;
Query OK, 0 rows affected (0.00 sec)