--- In firebird-support@yahoogroups.com, "Alan McDonald" <alan@...> wrote:

>
> Windows FB 2.1 Superserver
> I have an After Delete Trigger on Table A
> IF (CURRENT_ROLE='ROLEONE') THEN BEGIN
> UPDATE TABLEB SET FIELD='value' WHERE ID=OLD.FKFIELD;
> END
>

Hi, You have to grant permissions to TRIGGER

grant select, update on TABELB to trigger TABLEA_AD0;

Tom