I have written a CLR scalar valued function that queries a table using the context connection. This is working fine as long as the db user has select right on the table that is queried from within the CLR function. If the db user has no select right on the
table I am receiving the following error:
The SELECT permission was denied on the object '...', database '...', schema 'StD'.
I do not want to give the user select right on the table. How can I allow the CLR function to query the table without granting select right to the db user?
I have created the assembly with PERMISSION_SET = SAFE. Do I have to apply PERMISSION_SET = UNSAFE or is there any other way?
Thanks and kind regards
Softfount IT Solutions
View Complete Post