Dan,
To
create a view on a table, you must have Select granted directly to your User,
not just via a Role, which works for Selects.
Maybe
that's it.
Jack
--------------------------------
Jack C.
Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit,
Inc.
Austin,
Texas
www.iNetProfit.com
[EMAIL PROTECTED]
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Dasko, Dan
Sent: Thursday, April 05, 2001 11:36 AM
To: Multiple recipients of list ORACLE-L
Subject: Select won't work for view createI have a select that works fine. However, it doesn't work fine when I try to create a view of the result set. There is nothing particularly fancy about the query, just a plethora of outer joins from the main table to the secondary tables. I get an error back about one of the tables not existing, but like I said, it works as a select, just not as a create view as ...FWIW Oracle 8.0.6 on DG-UXDan
