Why can’t I grant exec rights on my user defined function in SQL Server?
Well, I did it again. Scratching my head I inspected the function and it was staring me right in the face–it returns a table. So, I needed to grant SELECT rights–not EXECUTE rights.
Let me know if this helps you!