1,633 questions

3,178 answers

1,706 comments

478 users

Grant permission to TVF sql function for custom ui model

0 votes

Is there a way to provide permission to select on a table valued function for a custom ui model? This is for the CustomUIModelMetaData spec with a uimodel attached.

asked Nov 28 by nolan-regenwether (139 points)   1 3 10

1 Answer

+1 vote
 
Best answer

If at all possible you shouldn't be making calls to the database from the ui model. You'd want to create a data form and do your selecting in there. That way you can access that data from the ui model and do everything you want from there. If you have to make the call then just write a grant sql statement and run it.

answered Nov 29 by chriswhisenhunt (3,850 points)   8 25 43
selected Dec 5 by nolan-regenwether

Awesome, I will create a data form. Thanks for your help!

...