How to grant "Execute" permission for User Defined Table Type?

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:

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

With Execute

Take it easy!

RECENT POST