SQL CLR Sproc isn't running right

S

Smokey Grindel

I have a stored procedure for SQL Server 2005 which is done with the CLR...
when its executed as a admin it works. when its executed as a non-admin it
doesn't work... any ideas? the user has permission to execute the procedure
on the server... seems to be something with the .NET SPROC's that is going
wierd
 
W

William Vaughn

What errors are being thrown? What does the SP do? What security setting
does it use? Can we see the SP?

--
__________________________________________________________________________
William R. Vaughn
President and Founder Beta V Corporation
Author, Mentor, Dad, Grandpa
Microsoft MVP
(425) 556-9205 (Pacific time)
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
____________________________________________________________________________________________
 
S

Smokey Grindel

Well here is the wierd thing... I put a handler on the info messages event
of the connection to see what was being said.. and I got a permissions error
back saying DBO doesn't have permission to insert records into the table...
why does DBO needs this? shouldn't it already have it? all my plain text
stored procedures work fine inserting data when executed as a user that has
no permissions to insert into a table... the user has execute permission on
all the stored procedures... so not sure why its saying DBO doesnt have
permission... any ideas? as for seeing the SP cant really show it since it
contains company info in it... but the assemblie's stored procedures do all
have execute permissions set for the role that the executing user is in...
 
W

William Vaughn

Ah, did you grant rights using the SQL Server 2005 Surface Area Config tool?


--
__________________________________________________________________________
William R. Vaughn
President and Founder Beta V Corporation
Author, Mentor, Dad, Grandpa
Microsoft MVP
(425) 556-9205 (Pacific time)
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
____________________________________________________________________________________________
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

CLR problems with security under ADO.NET and SQL Server 2005 2
Problems with LINQ and CLR Stored Procedure 1
Unable to start TSQL Debugging. Could not attach to SQL Server Process on 'srvname'. The RPC server 1
SQL Server Application Roles 1
CLR stored procedures in TableAdapter: no fields are populated? 6
T-SQL Return row affected count in CLR proc? 9
Sproc performance over vpon 12
Call stored procedure in SSMS from Access 2016 doesn't work. 0

Top