mysql 函数执行权限

mysql> show grants for query_all@'115.236.1x0.x';
+-----------------------------------------------------------------------------------------------------------------------+
| Grants for query_all@115.236.1x0.x                                                                                   |
+-----------------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'query_all'@'115.236.1x0.x' IDENTIFIED BY PASSWORD '*17167D048E538ED16DF5BD732EF9E1B2D9048F6E' |
| GRANT SELECT, EXECUTE ON `zjzc`.* TO 'query_all'@'115.236.1x0.x'       



GRANT USAGE ON *.* TO 'query_all'@'%' identified by '1234567';

GRANT SELECT  ON `zjzc`.* TO 'query_all'@'%';


这样的权限情况下:
Error Code: 1370. execute command denied to user 'query_all'@'%' for routine 'zjzc.loadTreeByParent'


会权限不足,而且也看不到函数内容；


加上执行权限后:

GRANT SELECT , EXECUTE ON `zjzc`.* TO 'query_all'@'%';


此时 可以执行函数,可以看到函数名,但是看不到函数内容

转载于:https://www.cnblogs.com/zhaoyangjian724/p/6199429.html