I'm developing a .Net App that calls an stored procedure that have a table valued parameter declared as a TYPE READONLY.
First time I tried to call the SP I received the next error:
Msg 229, Level 14, State 5, Line 1
The EXECUTE permission was denied on the object 'TYPE_OBJ', database 'MY_DB', schema 'dbo'.
After granting EXECUTE permission to the user it works fine.
Where can I find information about the necessary permissions to use a TYPE as a parameter?