June 28, 2022 . 1 MIN READ
Apparently I needed to do GRANT EXECUTE ON FUNCTION instead of GRANT EXECUTE ON PROCEDURE.
You’d think that if GRANT EXECUTE ON PROCEDURE only worked on PROCEDUREs that the error message ought to say “Error Code: 1305. PROCEDURE businessDayDiff does not exist” instead of “FUNCTION or PROCEDURE”…
Reference:
https://stackoverflow.com/questions/38559083/error-code-1305-function-or-procedure-does-not-exist