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

Hah hah hah ... of course. Doh.

Thanks Toon (and Niall)




________________________________
From: Toon Koppelaars <toon.koppelaars_at_rulegen.com>
To: david <david_at_david-aldridge.com>
Cc: oracle-l <oracle-l_at_freelists.org>
Sent: Mon, 7 March, 2011 11:14:42
Subject: Re: ORA-01031: insufficient privileges on view creation. 10.2.0.4

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_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