Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 273
  • Last Modified:

MYSQL user permissions to only run stored procedures

I would like to setup my database so specified users can only run stored procedures.  I don't want them to be able to log into the db with a gui and be able to write queries or edit the tables directly.  Also I don't want them to be able to alter the stored procedures.  Is this possible?

Thanks
0
mdrapiza
Asked:
mdrapiza
1 Solution
 
PranjalShahCommented:
I have not tested it but you can try the following... MySQL 5.1.48 and later should work with this.

Create a new database user and gave him permission to execute only one command: EXECUTE.
mysql> GRANT EXECUTE
-> ON database.*
-> TO username@localhost
-> IDENTIFIED BY 'password';
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now