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

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