Re: DB access for web apps
From: Rafal W. (RafalW_at_discussions.microsoft.com)
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
> "Rafal W." <RafalW@discussions.microsoft.com> wrote in message
> > I have custom .net web based application running on IIS 6 which has
> > 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
> > 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