Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: schema/trigger

Re: schema/trigger

From: S2 <email_at_mail.com>
Date: Tue, 08 Oct 2002 17:23:32 GMT
Message-ID: <3DA31492.2060501@mail.com>


MB wrote:
> I want to do something on an table in the schema y when there is a new entry
> in another table in schema x (same database). How can I do this?
>
> matthias
>
>
>
>

use dot notation after you gave the apropriate rights. for example, to access table t in schema y, from a trigger on schema x, user y.t

-- 

regards,
Simon
Received on Tue Oct 08 2002 - 12:23:32 CDT

Original text of this message

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