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 -> Re: Privilege on V$ view for Developers

Re: Privilege on V$ view for Developers

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 27 Jun 2006 20:40:21 +0200
Message-ID: <apu2a21q82ifobd3q6urfrmsmopcq8h7nr@4ax.com>


On Tue, 27 Jun 2006 12:05:30 -0400, meathammer <googler_at_google.com> wrote:

>what V$ views should an Oracle developer have SELECT privilege on ?
>
>v$process, v$session. v$version...what else ?
>
>thanks

v$process : why?
v$session : why?
v$version: why, there is a function in dbms_utility to retrieve the
version. Everyone has access to dbms_utility. v$mystat, probably, provided the developer does know what to do with it.
--
Sybrand Bakker, Senior Oracle DBA
Received on Tue Jun 27 2006 - 13:40:21 CDT

Original text of this message

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