Why can't I grant exec rights on my user defined function in SQL Server?
Well, I did it again. Scratching my head I inspected the function and it was staring me right in the face--it returns a table. So, I needed to grant SELECT rights--not EXECUTE rights.
Let me know if this helps you!
15 comments:
This helped me -- thank you.
Thanks, saved me a lot of time!
Yes, thanks
Helped me too, I was doing the exact same thing.
Super helpful. Many thanks!
Helped me too. Thanks!
Thanks, this helped me
Helped me too. Thanks!
Thanks, It helped me as well :)
Thanks! :)
Thanks - worked for me!
I know others have said it, but thanks for posting this. Saved me time and frustration.
+1
THANKS! It saved me from frustration. Wish I learned this earlier!
Wonderful!!
Post a Comment