What permission is needed to SHOW CREATE PROCEDURE?

I have users who should be able to see the definition of a procedure without the permission to execute it. However, running SHOW CREATE PROCEDURE on v 6.8.9 currently returns an error that “SHOW CREATE FUNC” is denied. When attempting to grant “SHOW CREATE FUNC” I get a syntax error. I’ve found MySQL documentation that says the user should have SELECT granted on the mysql.proc table, but that table doesn’t appear to exist in MemSQL. How can I give my users the access they need?

I think currently users need to have CREATE ROUTINE or ALTER ROUTINE permission on the said procedure to view the body of that procedure.
We have an internal feature request for adding a separate more granular permission that just allows to view the body of the procedure. Probably will be available in memsql release after 7.0

You see list of all permissions here:https://docs.memsql.com/v6.8/reference/sql-reference/security-management-commands/permissions-matrix/