Re: view creation problem

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 28 Dec 2000 23:18:18 +0100
Message-ID: <978082577.10564.0.pluto.d4ee154e@news.demon.nl>

as views are compiled there are two remarks to be made 1 You need to have *direct* priv instead of priv *through a role* 2 You shouldn't use * in view definitions, as this is resolved at creation time, *not* at runtime.

Regards,

Sybrand Bakker, Oracle DBA

"Eoin Gardiner" <eoin7_at_my-deja.com> wrote in message news:92g7rm$sos$1_at_nnrp1.deja.com...
> I am using Oracle 8.1.6 on NT.
>
> I am trying to create a simple view for a user.
>
> The command
> SELECT * FROM ADDRESSES
> works fine,
> but the command
> CREATE VIEW ADDRESSES_VW AS SELECT * FROM ADDRESSES
> gives the error
>
> ERROR at line 1:
> ORA-00942: table or view does not exist
>
> How can I have select privileges on the addresses table, yet cannot
> create a view on the same table?
>
> Thanks
>
>
> Sent via Deja.com
> http://www.deja.com/
Received on Thu Dec 28 2000 - 16:18:18 CST