Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> view creation problem
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 - 14:29:51 CST