Re: DB access for web apps

From: Rafal W. (RafalW_at_discussions.microsoft.com)
Date: 03/21/05


Date: Mon, 21 Mar 2005 13:39:02 -0800

thanks for response, will this allow execute sp_ ?

"Dejan Sarka" wrote:

> For a qick improvement, membership in the
> db_datareader (can select all data from any user table in the database) and
> db_datawriter (can modify any data in any user table in the database)
> roles should be enough. Then you can study grainer permissions needed.
>
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> www.SolidQualityLearning.com
>
>
> "Rafal W." <RafalW@discussions.microsoft.com> wrote in message
> news:5045D447-656F-46C8-A48E-29078FFAA294@microsoft.com...
> > I have custom .net web based application running on IIS 6 which has
> SQL2000
> > running in background, access to this application is based on UIDs and
> > password from "users" table in SQL, my question is regarding web.config
> > file... this file has user name and password that allow web application
> talk
> > to SQL db, what sql role should this account have in order to .net
> > application work corectly? db owner will do but I'm wondering this is too
> > much...
> >
> > TIA
>
>
>