Joseph Frantz

DELIMITER $$

DROP PROCEDURE IF EXISTS executeonly$$
CREATE PROCEDURE executeonly(IN in_person VARCHAR(50))

BEGIN

REVOKE ALL PRIVILEGES ON *.* FROM in_person@'localhost';

REVOKE GRANT OPTION ON *.* FROM in_person@'localhost';

GRANT EXECUTE ON *.* TO in_person@'localhost' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;

END$$

DELIMITER ;