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


--
Björn Reimer - RRZE