执行存储过程提示 user does not have access to metadata required to determine stored procedure解决方案
来源:互联网 发布:聊天机器人软件下载 编辑:程序博客网 时间:2024/05/17 22:57
在项目中往往会用到存储过程来统计一些比较复杂的报表,如果数据库是mysql,则需要在执行存储过程前需要为用户添加权限,才可以,否则会提示:
mysql User does not have access to metadata required to determine stored procedure parameter types错误。
方法如下:
1.GRANT SELECT ON mysql.proc TO 'testuser'@'%';
2.GRANT EXECUTE ON testdb.* TO 'testuser'@'%' ;
在sqlyog中使用testuser用户登录调用存储过程进行测试
CALL pro_get_order(1,'鲁J',258,'20170501','20170701');
阅读全文
0 0
- 执行存储过程提示 user does not have access to metadata required to determine stored procedure解决方案
- JDBC连接执行 MySQL 存储过程报权限错误:User does not have access to metadata required to determine stored procedur
- JDBC连接执行 MySQL 存储过程报权限错误:User does not have access to metadata required to determine stored procedur
- JDBC连接执行 MySQL 存储过程报权限错误:User does not have access to metadata required to determine stored procedur
- java.sql.SQLException: Userdoes not have access to metadata required to determine stored procedurepa
- SSRS 2014 User Domain\User does not have required permissions.
- User Domain\User does not have required permissions
- 存储过程 stored procedure
- 存储过程(Stored Procedure)
- Stored Procedure/存储过程
- 存储过程 Stored Procedure
- 存储过程(Stored Procedure)
- Mac Os, Android Studio 升级提示:Android Studio does not have write access to /Applications/Android Studi
- 存储过程(Stored Procedure)
- 存储过程(Stored Procedure)
- 存储过程(Stored Procedure)
- 存储过程(Stored Procedure)
- 存储过程(Stored Procedure)
- 关于百度富文本编辑器UEditor中ctrl+enter键发送消息的解决方案
- 手动切换漂移IP
- 仿ios风格dialog
- Scrum Master角色可能消失吗?
- Java线程:概念与原理
- 执行存储过程提示 user does not have access to metadata required to determine stored procedure解决方案
- 如何把直播嵌入网页
- 位操作基础篇之位操作全面总结
- 安卓的adb常用命令
- Path Sum 二叉树中和为某一值的路径
- maven打包
- [机器学习入门] 李宏毅机器学习笔记-9 (“Hello world” of deep learning;初探深度学习)
- Cloudera Manager的搭建及hadoop组件的安装
- tensorflow1.1的几个api变动