MSQL Reject all queries except stored procedures

For security reasons, I am thinking if its possible to organize MSQL server in a way to reject any kind of query from any user except Stored Procedures which already saved and marked as trusted on a server?

Answers


REVOKE ALL PRIVILEGES, GRANT OPTION FROM user;
GRANT EXECUTE ON PROCEDURE mydb.myproc TO 'someuser'@'somehost';

http://dev.mysql.com/doc/refman/5.1/en/grant.html#grant-routine-privileges


Need Your Help

configure mod_proxy_wstunnel on apache 2.4.x

apache configuration centos

I want to use mod_proxy_wstunnel on my CentOS machine. So, I went through the documentation and it says that, this module is the part of Apache >= 2.4.5 but, I'm not able to use the Module and

To get the data from the list into JSON format

c# json list var

Below is my code to get the JSON data,