<div>
so you would recommend a 'select' instead for a Table-valued function, if he needs to be able to use (query against) the function.?
</div>


so you would recommend a 'select' instead for a Table-valued function, if he needs to be able to use (query against) the function.?

<div>
I tried select; now i get<br />
Granted or revoked privilege SELECT is not compatible with object.
</div>


I tried select; now i get
Granted or revoked privilege SELECT is not compatible with object.

<div>
sorry, my bad.. it hit the wrong function.. select works ok.<br />
<br />
thank you.
</div>


sorry, my bad.. it hit the wrong function.. select works ok.

thank you.

<div>
<div class="content wysiwyg-content">
When I run the foll, I get the above error. The function does exist. The other functions were able to receive exec permissions...<br />
&quot;<br />
grant exec on funcname TO sql_auth_user<br />
&quot;<br />
<br />
thanks
</div>
</div>


When I run the foll, I get the above error. The function does exist. The other functions were able to receive exec permissions...
"
grant exec on funcname TO sql_auth_user
"

thanks

Granted or revoked privilege EXECUTE is not compatible with object.

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.