Subject | confusion trigger |
---|---|
Author | Virna Constantin |
Post date | 2013-04-20T05:50:03Z |
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]
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]