SQL server - Permission issues : Execute permission denied on object '

[sujal]

I have an ASP>NET application that uses Integrated Windows authentication. My Web.config looks like below

<add key="dbconnection" value=" server=XXX;Initial Catalog=XXX;persist security info=False;Integrated Security=SSPI;Pooling=true" />

When users try to access my application, they get the below error:

Execute permission denied on object 'SprocName', database 'DBNAME',Owner,'dbo'

The Only way I could get rid off the error is if I set DBO permissions for the user group on the databse.

Can someone suggest how to set up a security group with the ‘necessary’ permissions on SQL SERVER (ie read,write execute Sproc etc) and not too many extra ones, like DBO.

Thanks,

 

[mrdenny]

Create a database role called "WebUsers" or something like that.

Then grant execute writes to the necessary stored proces to the WebUsers database role. Make all your users members of the WebUsers database role.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com