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 <[email protected]> > >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]
