From: David Fitzjarrell <oratune@aol.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: which database i am using?
Date: Tue, 12 Dec 2000 14:38:02 GMT
Organization: Deja.com - Before you buy.
Lines: 25
Message-ID: <915d89$dqu$1@nnrp1.deja.com>
References: <915ck8$d9o$1@nnrp1.deja.com>
NNTP-Posting-Host: 64.19.63.135
X-Article-Creation-Date: Tue Dec 12 14:38:02 2000 GMT
X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0)
X-Http-Proxy: 1.1 x63.deja.com:80 (Squid/1.1.22) for client 64.19.63.135
X-MyDeja-Info: XMYDJUIDddf_dba


In our last gripping episode senthil <rsenthilkumar@my-deja.com> wrote:
> hi,
>
> i am an user without dba priveleges and would like to query a
> table/view that gives the database name. anybody knows the table/view
> name???
>
> thanks,
> senthil.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Yes, it's V$DATABASE, but you won't be able to access it without DBA
privileges.  I cannot find another table/view containing this
information accessable to non-DBA accounts.

--
David Fitzjarrell
Oracle Certified DBA


Sent via Deja.com http://www.deja.com/
Before you buy.