Re: query in trigger to another schema

Hi,

    the user that owns the trigger probably does not have privileges on the table auth.user.

auth needs to grant select on user to the user that owns the trigger.

News via skynet wrote:

> Hi,
>
> In a trigger in a particular schema I want to retrieve data from another
> schema AUTH. While doing this the compiler gives PLS-00201. I have to
> declare the identifier somehow. Any clues?
>
> my query in the trigger:
>
> BEGIN
> SELECT USER.NAME FROM AUTH.USER
> WHERE USER.NAME = :new.USER;
> ....
>
> END;
Received on Tue Mar 19 2002 - 16:13:09 CET