• Create a Role using CREATE ROLE

    Then grant execute on the functions to the role GRANT EXECUTE ON .... TO rolename

    Then add the user to the role sp_addrolemember rolename, username