--- In firebird-support@yahoogroups.com, PenWin <penwin@...> wrote:

> Now with the loggins tables, I have this sequence:
>
> 1) User INTERNET calls procedure INTERNET_INSERT_ROW.
> 2) Procedure INTERNET_INSERT_ROW validates data and writes it to SOMETABLE.
> 3) AFTER INSERT trigger LOGTRIGGER_SOMETABLE fires.
> 4) LOGTRIGGER_SOMETABLE writes the new record from SOMETABLE to LOGTABLE.
>
> Unfortunately, at step #4 I am getting an error no permission for
> insert/write access to TABLE LOGTABLE, and after a number of failed
> attempts, I am at a loss what to do.

GRANT INSERT ON LOGTABLE TO TRIGGER LOGTRIGGER_SOMETABLE

Regards,
Vlad