Re: SQL CLR Sproc isn't running right

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@xxxxxxxxxx> wrote in message news:%23ItGriGZIHA.1184@xxxxxxxxxxxxxxxxxxxxxxx
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@xxxxxxxxx> wrote in message news:835BD744-5FC7-4298-9AAF-19C6844FA906@xxxxxxxxxxxxxxxx
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@xxxxxxxxxx> wrote in message news:uEaLVQ3YIHA.5984@xxxxxxxxxxxxxxxxxxxxxxx
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





.

Relevant Pages

  • Re: user to execute nothing but SP in 2005
    ... What explicit permission I need to give. ... permission and then just grant Execute (I also tried to grant connect ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (microsoft.public.sqlserver.security)
  • Re: Executin DTSrun Utility under the xp_cmdshell
    ... When you grant execute permissions to users, the users can execute any operating-system command at the Microsoft Windows NTR command shell that the account running Microsoft SQL ServerT has the needed privileges to execute. ... You may, however, grant other users permission to execute this stored procedure. ... When xp_cmdshell is invoked by a user who is a member of the sysadmin fixed server role, xp_cmdshell will be executed under the security context in which the SQL Server service is running. ...
    (microsoft.public.sqlserver.dts)
  • Re: Stored Procedure Security/Permissions
    ... Cross-Database Ownership Chaining Behavior Changes in SQL Server 2000 ... > permission to read either table; ... > permission to execute the stored procedure, ...
    (microsoft.public.sqlserver.security)
  • Re: Execute stored procedure only
    ... Should I not be able to just execute SP ... What I meant is that since you denied every database permission you saw, ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (microsoft.public.sqlserver.security)
  • Re: System.Security.SecurityException was unhandled
    ... The exception gave you the CLSID. ... the first thing to check might be whether the COM server ... assembly actually has the permission in question. ... When I execute the application I received and error message. ...
    (microsoft.public.dotnet.security)