What can I say.. Yes.. I was careless about the syntax, thank you :)

But now, I have other problems, they never finish :P

The procedure I have insert, update and delete rows from 12 tables. Every table have 4-5 triggers associated with them and those triggers manipulate some other tables..

Even if I grant the Stored Procedure to select/insert/delete to the those tables which are in the body of the trigger, it says it still can't have access to those tables..

Do I need to grant the stored procedure to run the triggers or something like that too?

And am I boring you with this? :)

--- In firebird-support@yahoogroups.com, Doug Chamberlin <dougchamberlin@...> wrote:
>
> On 5/24/2010 9:58 AM, ardatun wrote:
> > Thank you again but it didn't work??
> >
>
> You still are not paying adequate attention to the GRANT statement syntax.
>
> You have issued a GRANT to user SP_TEST instead of PROCEDURE SP_TEST.
>
> Change from "GRANT SELECT ON MYTABLE TO SP_TEST;"
> to "GRANT SELECT ON MYTABLE TO PROCEDURE SP_TEST;"
>
>
> --
> Doug C.
> -----
> A: Because it messes up the order in which people normally read text.
> Q: Why is top-posting such a bad thing?
> A: Top-posting.
> Q: What is the most annoying thing in e-mail?
>