Ok. I knew that that was an option, but I have about 40 SPs....that's
a lot of permissions to grant (considering that I have to do one on a
case by case basis ...SP Foobar() might require SELECT access to table
BLA and UPDATE access to table FOO, a different SP would have
different needs). I see that there are some scripts that can ease
this, but what would be best is if those SPs ran as sysdba and I only
had to grant access to the test user to run the SPs.

--- In firebird-support@yahoogroups.com, Steve Wiser <steve@s...> wrote:
> 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]