SQL CLR Sproc isn't running right

  • Thread starter Thread starter Smokey Grindel
  • Start date Start date
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
 
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)
____________________________________________________________________________________________
 
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...
 
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)
____________________________________________________________________________________________
 
Back
Top