He is saying that you can grant select access on the table to the stored
procedure and then grant execute access on the procedure to the user...

-steve

On Fri, 2005-08-26 at 08:28 -0400, Jason Dodson wrote:

> 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.
> >
>
>
>
> ------------------------ Yahoo! Groups Sponsor
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>


[Non-text portions of this message have been removed]