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!
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!!