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

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