information_schema.role_routine_grants

obclient [test]> CREATE ROLE employee;

obclient [test]> DELIMITER //

obclient [test]> CREATE FUNCTION test.add_numbers(a INT, b INT)
RETURNS INT
BEGIN
      RETURN a + b;
END;//

obclient [test]> DELIMITER ;

obclient [test]> GRANT EXECUTE,ALTER ROUTINE ON test.add_numbers TO employee;

obclient [test]> GRANT employee TO user1;

obclient [test]> SET ROLE employee;

obclient [test]> USE information_schema;

obclient [information_schema]> SELECT * FROM information_schema.role_routine_grants;

+---------+--------------+-----------+--------------+------------------+-----------------+---------------+-----------------+----------------+--------------+-----------------------+--------------+
| GRANTOR | GRANTOR_HOST | GRANTEE   | GRANTEE_HOST | SPECIFIC_CATALOG | SPECIFIC_SCHEMA | SPECIFIC_NAME | ROUTINE_CATALOG | ROUTINE_SCHEMA | ROUTINE_NAME | PRIVILEGE_TYPE        | IS_GRANTABLE |
+---------+--------------+-----------+--------------+------------------+-----------------+---------------+-----------------+----------------+--------------+-----------------------+--------------+
| root    | %            | employee  | %            | def              | test            | add_numbers   | def             | test           | add_numbers  | Execute,Alter Routine | NO           |
+---------+--------------+-----------+--------------+------------------+-----------------+---------------+-----------------+----------------+--------------+-----------------------+--------------+
1 row in set