Grant permission to user to execute a Stored Procedure

by Vinoth 2009-03-23 14:13:30

If you want to allow user to execute Store procedure then use GRANT EXECUTE keyword

Allow user to execute all stored procedure
GRANT EXECUTE ON *.* TO 'user'@'localhost';

Allow user to execute all stored procedure attached with a single database
GRANT EXECUTE ON db_name.* TO 'user'@'localhost';

Allow user to execute a single stored procedure
GRANT EXECUTE ON db_name.sp TO 'user'@'localhost';

Tagged in:

3041
like
0
dislike
0
mail
flag

You must LOGIN to add comments