Re: v$ tables and stored procedures

From: Steve Moreland <smoreland_at_nospam.clientserver.com>
Date: Thu, 30 Jul 1998 11:16:09 -0400
Message-ID: <35c0920a.0@news.one.net>

A stored procedure executes with the permission's of it's owner.

Assuming that the owner of the stored procedure has explicitly-granted select rights on the table in question (e.g., not through a role), then grant your user execute access on your stored procedure.

HTH Steve

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 - 10:16:09 CDT