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 -> Re: trigger on table in other schema results in ORA-00942

Re: trigger on table in other schema results in ORA-00942

From: <frank.van.bortel_at_gmail.com>
Date: 26 Jan 2007 06:51:50 -0800
Message-ID: <1169823110.148539.158450@k78g2000cwa.googlegroups.com>

On 26 jan, 15:41, Stefan Wetter <swet..._at_arcor.de> wrote:
> 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

Show the code... one thing pops to mind: did you create the trigger on owner.table_name? Received on Fri Jan 26 2007 - 08:51:50 CST

Original text of this message

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