mysql / show procedure / grant

mysql / show procedure / grant

  • Written by Walter Doekes

  • Published on: 05/04/2013

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)
Back to overview