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.
But I can't find in MS-DOCS neither in CREATE TYPE nor in Use table-valued parameters any reference to the permissions needed to use it as a parameter.
Where can I find information about the necessary permissions to use a TYPE as a parameter?