CREATE ROLE 'test_role';

CREATE USER 'test_user'@'%' IDENTIFIED BY 'SDDSAghghgjhgsa123!!';

CREATE DATABASE `test_database`;

CREATE DEFINER='test_user' PROCEDURE `test_database`.`test_proc`() BEGIN END;

CREATE DEFINER='test_role' PROCEDURE `test_database`.`test_proc2`() BEGIN END;

CALL `test_database`.`test_proc`;

/* Output: execute command denied to user 'test_user'@'%' for routine 'test_database.test_proc' */

CALL `test_database`.`test_proc2`;

/* Output: execute command denied to user ''@'' for routine 'test_database.test_proc2' */

DROP DATABASE `test_database`;

DROP USER 'test_user';

DROP ROLE 'test_role';