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

epokopac_at_excite.com wrote:
> You may be able to solve this by creating a PUBLIC SYNONYM "TABLE" for
> "A.TABLE".
>

Why a PUBLIC synonym? I'd prefer it to be a private one. Although I doubt that this will solve the problem either as one needs CREATE ANY TRIGGER to create a trigger on another's table.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown