What is the difference between EXECUTE and EXECUTE PROCEDURE permission?
What is the difference between EXECUTE and EXECUTE FUNCTION permission?
GRANT EXECUTE ON object
= the right to execute a MACRO
GRANT EXECUTE ON PROCEDURE object or GRANT EXECUTE PROCEDURE ON object
= the right to CALL a PROCEDURE
GRANT EXECUTE ON FUNCTION object or GRANT EXECUTE FUNCTION ON object
= the right to use a FUNCTION