Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Privilege on V$ view for Developers
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 theversion. Everyone has access to dbms_utility. v$mystat, probably, provided the developer does know what to do with it.
-- Sybrand Bakker, Senior Oracle DBAReceived on Tue Jun 27 2006 - 13:40:21 CDT
![]() |
![]() |