• 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

RECENT POST
Please reload

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