-- Create a new role

CREATE ROLE SP_Fn_executor

-- Grant execute to the created role

GRANT EXECUTE TO SP_Fn_executor

The above statement would create a role and grant execute permission on all existing stored procedures and scalar functions.

And as when we create new ones the permission would automatically be given to the Role.