Grants for running a Stored Procedure

I have tested in my lab to grant execute permission for specified user to executing a PROCEDURE.It went well

1. Create PROCEDURE

DELIMITER // CREATE PROCEDURE get_all_cars() BEGIN SELECT * FROM manju; END // DELIMITER ;

2. CREATE USER 'TestUser1'@'%' IDENTIFIED BY 'XXXXX';

3. GRANT EXECUTE ON PROCEDURE manju.get_all_cars TO 'TestUser1'@'%'; FLUSH PRIVILEGES;

4. Login mysql client through TestUser1 and ran below command.

   CALL manju.get_all_cars;