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

From: Stefan Wetter <swetter_at_arcor.de>
Date: Fri, 26 Jan 2007 16:09:19 +0100
Message-ID: <45ba193f$0$18842$9b4e6d93@newsspool4.arcor-online.net>

frank.van.bortel_at_gmail.com schrieb:

> 
> 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?
> 

IDAV is former "a"
IDAV_TRANS_WALLAU is former "b"

CREATE OR REPLACE TRIGGER IDAV_TRANS_WALLAU.IDAV_A_IUD_R_ID_AUFTR AFTER DELETE OR INSERT OR UPDATE
ON IDAV.ID_AUFTR
FOR EACH ROW BEGIN     NULL;     EXCEPTION

      WHEN OTHERS THEN
        -- Consider logging the error and then re-raise
        RAISE;

END; Received on Fri Jan 26 2007 - 09:09:19 CST