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

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.

Take it easy!

RECENT POST
  • Grey Twitter Icon
  • Grey Facebook Icon
  • Grey LinkedIn Icon

© 2020 All rights reserved. PigeonSQL.com | Filip Holub

  • Twitter Social Icon
  • Facebook Social Icon
  • LinkedIn Social Icon