mysql修改函数权限后未生效,仍报错:execute command denied to user 'test'@'%' for routine 'tospur_house_user.function1'
修改执行权限sql即可:
GRANT EXECUTE ON FUNCTION lw.historynextval TO ‘UserA’@’192.168.10.61’
flush privileges
mysql修改函数权限后未生效,仍报错:execute command denied to user 'test'@'%' for routine 'tospur_house_user.function1'
修改执行权限sql即可:
GRANT EXECUTE ON FUNCTION lw.historynextval TO ‘UserA’@’192.168.10.61’
flush privileges