trigger on table in other schema results in ORA-00942

Hello again!

I have a user "a" with a table "table".
I have a user "b" with a table "changes".

Now i want user "b" to create a trigger (after update) on the table "a"."table".

I grant select, update, delete, alter on table "a"."table" to "b".

But if i try to create the trigger i get ORA-00942. Can anyone help?

Thanks!
Stefan Received on Fri Jan 26 2007 - 08:41:24 CST