mysql / show procedure / grant

mysql / show procedure / grant

  • Written by
    Walter Doekes
  • Published on

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 Newer post: Scan for new hotplug added disks Older post: python / twisted / exec environment