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

Home -> Community -> Usenet -> c.d.o.server -> why cannot I create a view on v$mystat

why cannot I create a view on v$mystat

From: fran0532 <wangping67_at_163.com>
Date: Thu, 02 Aug 2007 00:26:42 -0700
Message-ID: <1186039602.552358.263600@19g2000hsx.googlegroups.com> 





Hi,


I have the privilege on create any views on the database, and also I
have the select privilege on v$mystat, but I could not create the view
as below,


create view myView as select * from v$mystat, it says 'ORA-01031:
insufficient privileges', what the problem here and how to resolve it.



Thanks in advance,


Frank
Received on Thu Aug 02 2007 - 02:26:42 CDT












Original text of this message













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