ORA-01031: insufficient privileges on view creation. 10.2.0.4
- From: David Aldridge <david@xxxxxxxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Mon, 7 Mar 2011 03:07:46 -0800 (PST)
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*
Other related posts:
