Re: Access to v$views

From: Jurij Modic <jmodic_at_src.si>
Date: Sun, 18 Jul 1999 20:01:04 GMT
Message-ID: <37922cdd.22644670@news.siol.net>

On Sun, 18 Jul 1999 02:14:27 -0400, Doug Cowles <dcowles_at_bigfoot.com> wrote:

>So are they all conveniently in a table so that I can do this sort of thing?
>
>select 'grant select on v_$'||substr(viewname,3,........ to developer?

They are all listed in V$FIXED_VIEW_DEFINITION.

HTH, Jurij Modic <jmodic_at_src.si>
Certified Oracle DBA (7.3 & 8.0 OCP)

---

The above opinions are mine and do not represent any official standpoints of my employer Received on Sun Jul 18 1999 - 15:01:04 CDT