Re: Re: sys.v_$parameter

There is only one case when you should use V_$something instead of V$SOMETHING, which is when connected as SYS (or INTERNAL) to grant SELECT to a user who needs to create a stored procedure or view involving the said V$something. As Vladimir said, V$xxx is a synonym for V_$xxx, which is a (hard-coded) view on GV$xxx, itself a hard-coded view on a more or less complex brew of X$ tables (details in V$FIXED_VIEW_DEFINITION).
At least on the versions I have tried so far, GRANTing anything on the synonym doesn't work (you get an error saying that the only thing you are allowed to do with dynamic views is SELECT from them).
However, no problem to grant SELECT on V_$...

Regards,

Stephane Faroult
Oriole Corporation

>On Jun 11, 2001 at 12:25:22AM, Greg Moore wrote:
>> Why would someone write a SQL*Plus script against sys.v_$parameter when you
>> want to find the value of an init parm, when instead you could code against
>> v$parameter?
>
>In fact you'll get the same result.
>v$parameter is a synonym for v_$parameter:
>grep -i 'cre.*syn.*v\$par' $ORACLE_HOME/rdbms/admin/catalog.sql
>
>--
>Vladimir Begun | Besides, REAL computers have a rename()
>http://vbegun.net/ | system call. :-)
>http://vbegun.net/wap/ | -- Larry Wall in
>me_at_vbegun.net | <7937_at_jpl-devvax.JPL.NASA.GOV>
>--
>

--
Diese E-Mail wurde mit http://de.mail-inspector.de verschickt
Mail Inspector ist ein kostenloser Service von http://www.is-fun.net

Der Absender dieser E-Mail hatte die IP: 195.25.229.12

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: sfaroult_at_oriole.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).