Re: Create Views

From: Jonathan Gennick <jonathan_at_gennick.com>
Date: Tue, 07 Mar 2000 03:17:46 GMT
Message-ID: <38ce70cf.19650656@netnews.worldnet.att.net>

You probably have access to B through a role. To create a view, you need SELECT access granted directly to your user-id.

Jonathan

---

jonathan_at_gennick.com
http://gennick.com
Brighten the Corner Where You Are

On Mon, 06 Mar 2000 11:16:28 GMT, topinoz_at_my-deja.com wrote:

>Hello to everybody
>
>I have some problems creating VIEW:
>
>I'm using Oracle 8 and with 2 tables A and B from 2 different DB,
>trying to execute these SQL statements:
>
>CREATE VIEW AX (NOME, COGNOME, PROVINCIA_NASCITA) AS
> SELECT A.NOME, A.COGNOME, B.PROVINCIA_NASCITA FROM A, B WHERE
>A.ID_RELAZIONE = B.ID_RELAZIONE ;
>
>but the system say "Table or View not exists" under the B of "FROM
>A,B", it does not see the table B.
>
>But if I try the statement:
>
>SELECT * FROM B;
>
>I see the table.
>
>What's wrong?
>
>I also have try to create a synonym for B but nothing.
>
>TNX to all that help me.
>
>Pietro
>
>
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Mon Mar 06 2000 - 21:17:46 CST