Re: SQL Accounts

From: Gary (clgary_at_yahoo.com)
Date: 05/27/04 

Date: Thu, 27 May 2004 14:37:41 -0500

Hi Hari,

Unfortunately, neither role grants execute. I'd rather not have want to go
and add the execute priveledge to a given for a new procedure.

Do you know if that is possible?

That covers most of it,
"Hari" <hari_prasad_k@hotmail.com> wrote in message
news:e0Tv9f$QEHA.3580@TK2MSFTNGP11.phx.gbl...
> 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?
> >
> >
>
>