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 -> v$ tables and stored procedures

v$ tables and stored procedures

From: <jpoconnell_at_my-dejanews.com>
Date: Wed, 29 Jul 1998 20:54:27 GMT
Message-ID: <6po263$juf$1@nnrp1.dejanews.com>


Does anyone know what permission needs to be set to allow a user access to the v$ tables inside a stored procedure. I already set the user to have dba permission, with that I can select from the tables in sql*plus but not in a stored procedure.

Thanks Jerry

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Wed Jul 29 1998 - 15:54:27 CDT

Original text of this message

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