Re: ORA-01031: insufficient privileges on view creation. 10.2.0.4
- From: Toon Koppelaars <toon.koppelaars@xxxxxxxxxxx>
- To: david <david@xxxxxxxxxxxxxxxxxx>
- Date: Mon, 7 Mar 2011 05:14:42 -0600
David,
Do you have either a direct select privilege or one via PUBLIC on that
table?
Cannot be via a role.
On Mon, Mar 7, 2011 at 5:07 AM, David Aldridge <david@xxxxxxxxxxxxxxxxxx>wrote:
> 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*
>
--
Toon Koppelaars
RuleGen BV
Toon.Koppelaars@xxxxxxxxxxx
www.RuleGen.com
TheHelsinkiDeclaration.blogspot.com
(co)Author: "Applied Mathematics for Database Professionals"
www.rulegen.com/am4dp-backcover-text
Other related posts:
