top of page
  • Twitter Social Icon
  • Facebook Social Icon
  • LinkedIn Social Icon
Search

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

  • Writer: Filip Holub
    Filip Holub
  • Jun 2, 2018
  • 1 min read

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!

 
 
 

Comments


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

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

bottom of page