How to Grant Execute Procedure to User

<<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)