I now suffer from "trigger granting", (Trigger Rights Management,TRM?)

It is the same thing in the thread "Rights confusion with stored procedures and triggers"

After spending 2 hours with my 12 tables, more than 60 triggers with them, and with many other tables inside of those triggers, I still can't find out why a single procedure still gives "insufficent SQL rights" error. The error message I receive is insufficient and I can't find out which object cannot access the table mentioned. It just says "SP_TEST has insufficient SQL rights". I tried to search and find from the extracted metadata, still unsuccesfull.

In my opinion granting procedures for some capability are okay but granting triggers? It's of course very well work done with brilliant coders and I respect it but is it really necessary?

If it's necessary security mechanism, a more descriptive error would be very helpfull.

--- 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?
>