Re: v$ tables and stored procedures

From: Murali Kazhipurath <murali_at_jps.net>
Date: Thu, 30 Jul 1998 01:58:10 -0700
Message-ID: <35c03614.0@blushng.jps.net>

You have to grant permissions directly to the user instead of granting it via a ROLE.

i.e., grant select on v$table to scott

Hope this helps.

Murali Kazhipurath

jpoconnell_at_my-dejanews.com wrote in message <6po263$juf$1_at_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 Thu Jul 30 1998 - 03:58:10 CDT