It is not possible to grant permission to triggers from what I know (FlameRobin)

Possibly if the trigger break into two parts, one with insert and update, other with delete solve the problem.
In the end I granted the right to delete on table Tab2.

>________________________________
> From: Björn Reimer <bjoern.reimer@...>
>
>Are you aware of the possibility to grant permissions to triggers?
>
>That should solve your problem.
>
>  
>> Why User1 is restricted for any insert or update operation ?
>>
>> User1 privileges:
>> Tab1 - select,insert,update,delete
>> Tab2 - select,insert update
>>
>> Trigger Tab1_BA BEFORE Insert or Update or Delete
>> Begin
>>  if (inserting) then
>>  begin
>>    ...
>>  end
>>
>>  if (updateing) then
>>  begin
>>    ...
>>  end
>>
>>  if (deleting) then
>>  begin
>>    delete from Tab2 where ...
>>  end
>> End
>>
>> I know that this problem is solved if we add to Tab2 delete
>> but why is not correct formulation above
>
>
>
>
>Björn
>
>

[Non-text portions of this message have been removed]