Sample:
GRANT SELECT, INSERT, UPDATE, DELETE ON test_1.* to user1@'192.168.122.10%';
user1 can SELECT, INSERT, UPDATE and SELECT on tables in database test_1.
After adding
grant execute on `test_%`.* to user1@'192.168.122.10%';
user1 gets permission denied when trying to access a table in test_1.
Customer environment has several databases all with a suffix per client company and DBA wanted to grant EXECUTE permission for all databases in one statement.
Workaround in this case:
Explicitly GRANT EXECUTE for each database.