Home -> Mailing Lists -> Oracle-L -> ORA-01031: insufficient privileges on view creation. 10.2.0.4

ORA-01031: insufficient privileges on view creation. 10.2.0.4

From: David Aldridge <david_at_david-aldridge.com>
Date: Mon, 7 Mar 2011 03:07:46 -0800 (PST)
Message-ID: <227725.23424.qm_at_web806.biz.mail.mud.yahoo.com> 





Does anyone have any ideas why a username that can both create a view and can 
run a particular SELECT could not create a view based exactly on that SELECT?


10.2.0.4

So, I can successfully run this query:

select
  s.shelfid ,
  cns.nodeid
from
  cramer_node_snapshot cns,
  shelf         s
where
  cns.nodeid              = s.shelf2node
/

Also I can create a view that does not reference SHELF:

create or replace view
  view1
as
select
  cns.nodeid
from
  cramer_node_snapshot cns
/


BUT!

I cannot create this view because of "ORA-01031: insufficient privileges":

create or replace view
  view1
as
select
  s.shelfid ,
  cns.nodeid
from
  cramer_node_snapshot cns,
  shelf         s
where
  cns.nodeid              = s.shelf2node
/

SHELF is one of nearly 22,000 public synonyms on this system. Referencing the 
SHELF object directly instead of through the public synonym does not change the 
error. No DB links involved.


*scratches-head*


--
http://www.freelists.org/webpage/oracle-l


Received on Mon Mar 07 2011 - 05:07:46 CST












Original text of this message