garconcn
Reputation: 285
How to grant EXECUTE Stored Procedure for a user in mysql
I am trying to grant EXECUTE Stored Procedure for a user in cPanel(the latest version 11.28.60), but it does not work. Should I create the Stored Procedure before grant the EXECUTE privilege? Thanks.
Upvotes: 1
Views: 1139
Answers (1)
Joe Stefanelli
Reputation: 135808
Yes, create the procedure first. The procedure has to exist before you can grant permissions on it.
Upvotes: 1
Related Questions
- MySQL Stored Procedure Permissions
- Mysql Procedure Error (execute command denied to user)
- Grant Execute Function permission to another user
- Stored procedure access denied for user to database
- How to grant a user access to all stored procedures on mysql?
- Execute a mysql stored procedure from the definer account, without execute privileges
- Allow GRANT in procedures?
- how can I make this user (Normal Users) permission to use the procedure
- How to grant execute on specific stored procedure to user
- Stored procedure privilege error