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 -> ALL_VIEWS in a stored procedure

ALL_VIEWS in a stored procedure

From: Stephen Hirsch <Stephen.Hirsch_at_pharma.novartis.com>
Date: Mon, 26 Apr 1999 16:00:18 -0400
Message-ID: <3724C5D2.59C5@pharma.novartis.com> 





Hi,



From a schema that SELECT ANY TABLE privilege, I can SELECT from the
ALL_VIEWS view. However, I tried creating a cursor that did a join on
the ALL_VIEWS table, and I got:



 PLS-00356: 'ALL_VIEWS' must name a table to which the user has
 access



What's up with that? Do I have access or not? I thought everybody had
access to ALL_VIEWS, whether they could see any rows or not.



Thanks,



Steve
Received on Mon Apr 26 1999 - 15:00:18 CDT












Original text of this message













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