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
