My colleague asked me " How Can I grant Execute rights for my User Defined Table Type"? - There is not execute option as you can see below

 

 

Without Execute Option

 

I found out that I can grant this type of this permission only vis T-SQL.

 

This query will help you:

 

GRANT EXEC ON TYPE::[dbo].[Type_AdvancedSearchCondition] TO [sa]

GRANT EXEC ON TYPE::[dbo].[Type_AdvancedSearchCondition] TO [SP\xp82]

 

If executed this query and check GUI again you can see granted execute permission as you can see below.

 

With Execute

 

 

Take it easy!

参考网址：

https://stackoverflow.com/questions/6870320/the-execute-permission-is-denied-on-the-user-defined-table-types

https://www.pigeonsql.com/single-post/how-to-grant-execute-permission-for-user-defined-table-type