|
|
Grant permission to user to execute a Stored Procedure - Mysql
|
Views : 1680
|
|
Tagged in : Mysql
|
|
|
Report This Scrap as Inappropriate
We request you to choose the appropriate categroy and subcategory that suits your
objectionable concern about the scrap, So that our team can review and find out whether it violates our Guidelines or the
scrap is not suitable for all viewers.
|
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';
|
|
By - Vinoth, On - 2009-03-23 |
|
|
|
