Thanks for the advice. I got it to work before reading your post.
For you information, I did search Google, but not this forum, so pay
up. A million and one times never hurt anyone.
On Jun 12, 4:58 pm, sybra..._at_hccnet.nl wrote:
> On Tue, 12 Jun 2007 20:40:41 -0000, simpsonjo..._at_gmail.com wrote:
> >Hi all,
>
> >I am having trouble creating aviewin aschemathat references tables
> >in anotherschema. For example. I want tocreateviewx_view in
> >schemaA that selects fields from Table b_tab inschemaB. SchemaA
> >has allviewprivileges granted to it (createanyview, drop anyview,
> >under anyview) as well as the select any table permission. When I
> >run the following query, I get an insufficient privileges error. Can
> >someone please help me out?
>
> >CREATEOR REPLACEVIEWa.x_view AS SELECT field1, field2 FROM b.b_tab;
>
> >and the error:
> >ERROR at line 1:
> >ORA-01031: insufficient privileges
>
> >Thanks,
> >John
>
> ora-1031 on compiled objects (aviewis compiled): *roles* are
> *disregarded* during compilation as roles are volatile.
> This has been posted here at least a million times.
> Did you search Google or this forum? I bet not.
>
> --
> Sybrand Bakker
> Senior Oracle DBA
Received on Tue Jun 12 2007 - 16:27:56 CDT
