Re: SQL Accounts

From: Hari (hari_prasad_k_at_hotmail.com)
Date: 05/27/04 

Date: Thu, 27 May 2004 20:06:15 +0530

Hi,

Assign the user db_datareader and db_datawriter database fixed roles.

Script is :-

sp_addrolemember 'db_datareader','<db_user>'
go
sp_addrolemember 'db_datawriter','<db_user>'

Thanks
Hari
MCDBA

"Gary" <clgary@yahoo.com> wrote in message
news:eXkNSm1QEHA.3608@TK2MSFTNGP10.phx.gbl...
> Hi,
>
> I'm having a bit of trouble figuring out the how to setup roles that
> basically grant EXECUTE, INSERT, SELECT, UPDATE, DELETE on a database.
Im
> trying to prevent CREATE, ALTER, and DROP. Does anyone have a reccomended
> practice of doing this?
>
>