Re: SQL CLR Sproc isn't running right by William
William
Fri Feb 01 13:46:46 CST 2008
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)
____________________________________________________________________________________________
"Smokey Grindel" <nospam@nospam.com> wrote in message
news:%23ItGriGZIHA.1184@TK2MSFTNGP04.phx.gbl...
> 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...
>
> "William Vaughn" <billvaNoSPAM@betav.com> wrote in message
> news:835BD744-5FC7-4298-9AAF-19C6844FA906@microsoft.com...
>> 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)
>> ____________________________________________________________________________________________
>> "Smokey Grindel" <nospam@nospam.com> wrote in message
>> news:uEaLVQ3YIHA.5984@TK2MSFTNGP06.phx.gbl...
>>>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
>>>
>>
>
>