Re: SQL Accounts

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

Date: Fri, 28 May 2004 12:40:27 +0530

Hi ,

Yes, I agree with you.

The solution for this is exclusively provide "GRANT EXEC" permission for
that user while creating the procedure.

Thanks
Hari

"Gary" <clgary@yahoo.com> wrote in message
news:uz8GuICREHA.2876@TK2MSFTNGP09.phx.gbl...
> 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?
> > >
> > >
> >
> >
>
>