• Grey Twitter Icon
  • Grey Facebook Icon
  • Grey LinkedIn Icon
  • Grey Google+ Icon

© 2016 - 2019 All rights reserved. PigeonSQL.com | Filip Holub

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

June 2, 2018

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!



Please reload

Please reload

  • Facebook Social Icon
  • Google+ Social Icon
  • LinkedIn Social Icon
  • Twitter Social Icon