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: gazzag <gareth_at_jamms.org>
Date: 26 Jan 2007 06:54:12 -0800
Message-ID: <1169823252.470451.158420@s48g2000cws.googlegroups.com>


On 26 Jan, 14: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

>From the documentation here:

http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_7004.htm#i2235611

"To create a trigger in any schema on a table in any schema, or on another user's schema (schema.SCHEMA), you must have the CREATE ANY TRIGGER system privilege"

HTH -g Received on Fri Jan 26 2007 - 08:54:12 CST

Original text of this message

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