RE: Select won't work for view create

From: Jack C. Applewhite <japplewhite_at_inetprofit.com>
Date: Thu, 05 Apr 2001 10:10:04 -0700
Message-ID: <F001.002E2DF3.20010405094727@fatcity.com>

<SPAN

class=078154716-05042001>Dan,
<SPAN

class=078154716-05042001> 
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.
<SPAN

class=078154716-05042001> 
Maybe
that's it.
<SPAN

class=078154716-05042001> 
<SPAN

class=078154716-05042001>Jack

--------------------------------Jack C. 

ApplewhiteDatabase Administrator/DeveloperOCP Oracle8 DBAiNetProfit, Inc.Austin,
Texaswww.iNetProfit.comjapplewhite_at_inetprofit.com

  <FONT face=Tahoma
  size=2>-----Original Message-----From: root_at_fatcity.com   [mailto:root_at_fatcity.com]On Behalf Of Dasko, DanSent:   Thursday, April 05, 2001 11:36 AMTo: Multiple recipients of list   ORACLE-LSubject: Select won't work for view   create
  I
  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   ... 
  <SPAN
  class=755183615-05042001> 
  FWIW
  Oracle 8.0.6 on DG-UX
  <SPAN
  class=755183615-05042001> 
  <SPAN
  class=755183615-05042001>Dan Received on Thu Apr 05 2001 - 12:10:04 CDT