<<Back to MySQL & MariaDB How To Page
How to Grant Execute Procedure to User in MySQL or MariaDB
Granting Execute on a Selected Procedure
GRANT execute ON procedure DB_Name.ProcName TO 'User_Name';
MySQL>GRANT EXECUTE ON PROCEDURE intdb.myproc TO 'app_test'@'localhost';
Query OK, 0 rows affected (0.00 sec)
Granting Execute for all Procedure in a Database
GRANT execute ON `DB_Name`.* TO 'User_Name';mysql> GRANT execute ON `testdb`.* TO 'app_test'@'localhost';Query OK, 0 rows affected (0.00 sec)
Comments
Post a Comment