Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Access to v$ views
On Tue, 07 Dec 2004 22:07:31 -0800, DA Morgan wrote:
> n_kselva_at_yahoo.com wrote: >
> > Depends on whether you are talking about development, testing, or a > production database. I can easily see a production application requiring > access to v$mystat, v$session, and others depending on functionality. > > In a development database I can't think of a single reason why everyone > should not have access to v$reserved_words.
How about developers thrashing the development database with frequent selects on v$sqlarea, or other expensive to use v$ views?
I don't think anyone other than the DBA needs unfettered access to all the v$ views.
And not even all of them can be trusted. Received on Wed Dec 08 2004 - 08:38:06 CST
![]() |
![]() |