• If this is scalar valued function, you have to give Grant Execute Permission on the function.

    On TVF you have to give Grant Select.