Subject confusion trigger
Author Virna Constantin
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

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