Re: ORA-01031: insufficient privileges on view creation. 10.2.0.4

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_at_david-aldridge.com>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_at_RuleGen.com
www.RuleGen.com
TheHelsinkiDeclaration.blogspot.com

(co)Author: "Applied Mathematics for Database Professionals"
www.rulegen.com/am4dp-backcover-text

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