From: "diversif" <diversif@ix.netcom.com>
Subject: Re: TRIGGERS referencing <different user> table
Date: 1997/06/06
Message-ID: <01bc728e$4a2cbe20$8398b8cd@newmicronpc>#1/1
References: <3397C74E.FA18FE17@technologist.com>
Organization: Diversified Inc.
X-NETCOM-Date: Fri Jun 06 10:26:54 AM CDT 1997
Newsgroups: comp.databases.oracle.server



Does User A have explicit select privileges on USER_B.TABLE.  If this
access has been granted via a role, this will not work.  To create a
'Stored Object' (view, package, trigger, function, procedure...) you can
not do this if you have privileges on the objects via a role.

Radek Hulan <ivan2000@technologist.com> wrote in article
<3397C74E.FA18FE17@technologist.com>...
> Could anyone help me about HOW to reference a different user table
> in BEFORE INSERT trigger? I want to fill in some :new fields which 
> were created under USER_A with values from tables created under 
> USER_B (by using simple select statement).
> 
> If I try something like SELECT xxx INTO :new.yyy FROM USER_B.TABLE
> WHERE ... (on USER_A.this_trigger), it doesnt work. I tried also 
> using synonyms, but with no luck.
> 
> Thanks in advance.
> 
> Radek Hulan
> e-mail: ivan2000@technologist.com
> Konojedska 33, Prague, Czech Republic
>