Granted or revoked privilege EXECUTE is not compatible with object

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!

15 thoughts on “Granted or revoked privilege EXECUTE is not compatible with object

  1. I know others have said it, but thanks for posting this. Saved me time and frustration.

Comments are closed.