注:调用前要给用户赋予相应权限
过程:GRANT SELECT ON mysql.proc TO 'user'@'localhost';
函数:GRANT SELECT ON mysql.func TO 'user'@'localhost';
取消权限:REVOKE SELECT ON mysql.func from 'user'@'localhost'
注:调用前要给用户赋予相应权限
过程:GRANT SELECT ON mysql.proc TO 'user'@'localhost';
函数:GRANT SELECT ON mysql.func TO 'user'@'localhost';
取消权限:REVOKE SELECT ON mysql.func from 'user'@'localhost'