Re: Developer Access to V$ Tables

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 25 Apr 2002 21:52:54 +0200
Message-ID: <ucgod4t17pbba6@corp.supernews.com>

"Buck Turgidson" <jc_va_at_hotmail.com> wrote in message news:b56b25e3bfa48014ce74518f3b300503.38849_at_mygate.mailgate.org...
> I am wondering what level of access developers are typically given to
> tables such as V$SESSION, V$SQLAREA, etc?
>
> I currently have access now, and find these tables extremely useful for
> debugging and analyzing performance problems.
>
> Our management, wise as they are, want to remove our access.
>
>
> --
> Posted via Mailgate.ORG Server - http://www.Mailgate.ORG

Unless you want to access them in stored procedures, granting the monitorer role (in ultmontr.sql) should do for general purposes. Also everyone has access to the v$mystat view. Practical Oracle 8i contains additional tips on this topic, it is lying in the office, so I don't have it handy now.

Hth

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address

Received on Thu Apr 25 2002 - 14:52:54 CDT