Re: create view on table on another schema

From: Jonathan Gennick <gennick_at_worldnet.att.net>
Date: 22 Aug 1998 02:00:56 GMT
Message-ID: <35e61be3.2254839@netnews.worldnet.att.net>

On 21 Aug 1998 09:31:49 -0200, "Loy&Hutz" <loyhutz_at_dinx.de> wrote:

>I logged in as user y (schemay)
>
>when I execute this:
>
>Create view view1 as select * from schemax.tab1
>
>I get th error "Schemax.tab1 does not exists.

I _think_ you need to have been granted access to the target table directly, rather than through a role. You may also need the REFERENCES privilege. Try logging on as SCHEMAX, and issuing the following command:

GRANT SELECT,REFERENCES ON TAB1 TO yourself;

Then try your view creation again.

Jonathan Received on Fri Aug 21 1998 - 21:00:56 CDT