在hibernate 中执行存储过程遇到的权限问题

最新推荐文章于 2021-01-28 03:49:13 发布

原创最新推荐文章于 2021-01-28 03:49:13 发布 · 190 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#Hibernate #MySQL #Access #SQL #JDBC

ruby 专栏收录该内容

140 篇文章

订阅专栏

本文介绍了解决MySQL中执行存储过程时出现的权限错误问题。通过授予特定用户对mysql.proc表的访问权限或者在连接字符串中添加&noAccessToProcedureBodies=true参数来规避此问题。

执行存储过程可能会遇到：User does not have access to metadata require
d to determine stored procedure parameter types

以下是解决的方法：[url]http://sql.dzone.com/tips/quick-tip-grating-access-meta-[/url]

If you have root access to your MySQL database then you can simply run a query on the database to resolve the problem. What the query will do is give the specified user the needed rights on the mysql.proc table. This takes the form of the following GRANT SQL query:

GRANT [SELECT, INSERT, UPDATE] ON `mysql`.`proc` TO 'myuser'@'myhost';

That's it, after running this query on the database the above exception goes away. If however, you do not have the needed root access to run this query on the database then below is the connection string to use to get around this problem. Very simple, just add &noAccessToProcedureBodies=true to your current connection string and you are done.

String connectionURL = "jdbc:mysql://localhost:3306/mydatabase?user=myuser&password=mypassword&noAccessToProcedureBodies=true"

I sincerely hope this tip will help out someone else. If not, well, then at least I now know where to go the next time I run into this problem :)