Re: view creation problem

From: <nickvysh_at_my-deja.com>
Date: Fri, 29 Dec 2000 01:27:59 GMT
Message-ID: <92gpaq$b39$1@nnrp1.deja.com>

SELECT privilege for a table must be granted to you directly, not through a role in order for you to be able to create a view based on that table.

In article <92g7rm$sos$1_at_nnrp1.deja.com>, Eoin Gardiner <eoin7_at_my-deja.com> wrote:
> 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/
>

Sent via Deja.com
http://www.deja.com/ Received on Thu Dec 28 2000 - 19:27:59 CST