Re: TRIGGERS referencing <different user> table

From: diversif <diversif_at_ix.netcom.com>
Date: 1997/06/06
Message-ID: <01bc728e$4a2cbe20$8398b8cd@newmicronpc>#1/1

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_at_technologist.com> wrote in article <3397C74E.FA18FE17_at_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_at_technologist.com
> Konojedska 33, Prague, Czech Republic
>
Received on Fri Jun 06 1997 - 00:00:00 CDT