SPs can only have execute permissions assigned.

Jason

Dmitry Sibiryakov wrote:

> On 26 Aug 2005 at 1:24, Robby wrote:
>
>
>>If I'm totally off on how I should go about doing this, then please
>>let me know.
>
>
> Have you ever heard that you can grant rights to objects
> (procedure, trigger or view)?
>
> Just grant select to your SP and grant execute to the user.
>