Re: Stored Proc security

I give you half a lemon for that question:). A simple search in either BooksOnLine or Google would have yielded the answer. Now that may sound rude but most answers posted here can be solved faster and easier for all involved by doing these simple searches. This was an attempt to get you (and others) in the habit of utilizing BOL as it is a wonderful tool that has most answers like this. In the long run it will save you lots of time.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors


"Arne Garvander" <ArneGarvander@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:862E90E3-CA35-4ACB-970F-A75FECD62770@xxxxxxxxxxxxxxxx
I give you half a lemon for that answer.
--
Arne Garvander
Certified Geek
Professional Data Dude


"Andrew J. Kelly" wrote:

Take a look at the GRANT statement in BooksOnLine and use the EXEC option.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors


"Arne Garvander" <ArneGarvander@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:C0DDE2D8-8997-4846-9146-0404A99755A1@xxxxxxxxxxxxxxxx
> How do I grant execute proc privileges in SQL Server 2005?
> -- > Arne Garvander
> Certified Geek
> Professional Data Dude



.

Relevant Pages