Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Privilege on V$ view for Developers
meathammer wrote:
> what V$ views should an Oracle developer have SELECT privilege on ?
>
> v$process, v$session. v$version...what else ?
>
> thanks
gv$reserved_words -- this should be a no-brainer gv$parameter gv$database gv$instance gv$version gv$session -- and they should be trained on how to use it. gv$mystat -- and they should be trained on how to use it.
I know a lot of DBAs think there is value in keeping developers in the dark but I've yet to see a good argument for not improving the quality of developers by giving them access and teaching them what to look for.
Morgan's library is being stripped of all references to v$ and they are being replaced with gv$ so that developers become RAC aware.
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Mon Jul 03 2006 - 11:42:14 CDT
![]() |
![]() |