Re: v$ tables and stored procedures

From: Suresh Bhat <suresh.bhat_at_mitchell-energy.com>
Date: Wed, 29 Jul 1998 21:33:20 GMT
Message-ID: <01bdbb48$46542140$a504fa80@mndnet>

First of all do not give any users dba privileges. It is dangerous unless you are the only user and the dba.

Secondly if you want to access tables inside procedures, packages and functions, you need to grant the access to those tables to the user explicitly with the grant command via dba account.

Lastly, v$ tables are really v_$tables. All v$tables are public synonyms.

Therefore, you should

grant select on v_$session to ops$username;

etc. for the v$tables that you want to give access to the users.

jpoconnell_at_my-dejanews.com wrote in article <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 Wed Jul 29 1998 - 16:33:20 CDT