SQL CLR Can not run on other machine

[Tianjin]

I wrote A SQL CLR Stroedprocdure using C# on my machine and then deployed it to SQL Server 2008 on our company server. I Create a crystal report called this stored procedure and it worked fine. However, when I run this report on the other machine, it gave me an error as "Failed to open rowset. detail: SELECT permission denied on object 'TblEmployee',database 'dnadata',schema'dbo'......". the machine I am working on has sysadmin role and other machine only has public role on it. if I give it sysadimn role, report can run without problem. however, it is not good practice to sovle this problem this way.

What Minimum permission should be assigned?


Thanks


tianjin

 

[markros]

Well, you need to give select permissions for the tblEmployee to the role you run this report with.

PluralSight Learning Library

 

[Tianjin]

Thanks, markros

It works. but instead of only give tblemployee a permission(because a lot tables are called in my clr). I give select permission to database and it all solved.

Thank again