create view on table on another schema

create view on table on another schema

e.g.:

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.

But if I execute only the select, it works.

I give user y the rights "Create view" and "create any view" but anyway ..

Any idea?

Thanks in advance

Sven Kunze Received on Fri Aug 21 1998 - 06:31:49 CDT