Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: error in creating view on v$

Re: error in creating view on v$

From: David Sharples <davidsharples_at_gmail.com>
Date: Wed, 16 Nov 2005 23:17:55 +0000
Message-ID: <be592d550511161517h3cee60a6i999ffab382c707@mail.gmail.com> 





you need to do it as sys - as sys owns the underlying objects to the view



On 11/16/05, Harvinder Singh <Harvinder.Singh_at_metratech.com> wrote:


>

> Hi,

>

> *

> ERROR at line 3:

> ORA-01031: insufficient privileges

>

> This user have a dba privileges. Do I need to give any other privileges

> to this user?

>

> Thanks

> --Harvinder

>



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


Received on Wed Nov 16 2005 - 18:21:09 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US