Re: I've now, officially, seen it all...

HansF wrote:
> On Fri, 12 Jan 2007 07:38:17 -0800, Mark D Powell wrote:
>
> > You would think that the "read only" status for a database would be
> > recorded in an X$ storage location and that querying it would be both
> > more efficient and more clean as to the purpose of the statement. In
> > fact I would think that v$database.open_mode would be usuable to
> > indicate this though I do not have a system available for testing.
> >
>
> How many of the X$ (and V$ and DBA_) views are available to the general
> user,and in particular to the general application?
>
> Seems to me this might be a fairly generic application trick to permit
> testing something without getting the DBA to make 'oh really, you want
> acces to what?' types of permissions.
>
> --
> Hans Forbrich (mailto: Fuzzy.GreyBeard_at_gmail.com)

I have a couple of vendor applications that specifiy that select is required on specific v$ views and then there are applications like MAXIMO that require creation of views owned by user SYS which in turn are based on Oracle base tables so I would think creating an application view on v$database would result in a more obvious test.

Still, I do not disagree that it is a slick way of finding something out without having access to the v$ views. Hopefully in the actual code the purpose of the statement is commented.

IMHO -- Mark D Powell -- Received on Sun Jan 14 2007 - 11:33:02 CST