Table valued functions can not be granted ‘EXECUTE’ permission

I found an error when I was trying to deploy my database project:

Granted or revoked privilege EXECUTE is not compatible with object on

After quick search on google, I learned that table valued functions can not be granted ‘EXECUTE’ permissions. Instead they need to be granted ‘SELECT’ permissions.

It makes sense and never realised this until I hit this problem. I have been using Table valued and Scaler valued functions and didn’t notice that you use select on table valued functions and execute on scaler valued functions.