Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> trigger on table in other schema results in ORA-00942

trigger on table in other schema results in ORA-00942

From: Stefan Wetter <swetter_at_arcor.de>
Date: Fri, 26 Jan 2007 15:41:24 +0100
Message-ID: <45ba12b4$0$18834$9b4e6d93@newsspool4.arcor-online.net>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US