Re: Database name

From: Frank Hubeny <fhubeny_at_ntsource.com>
Date: 2000/07/19
Message-ID: <397536ED.6E715597@ntsource.com>#1/1

There is a dbms_standard function called database_name that could be called by users that have only connect privilege (Linux, 8.1.5):

SQL> create user lowpriv identified by lowpriv;
SQL> grant connect to lowpriv;
SQL> connect lowpriv/lowpriv_at_myalias

Connected.
SQL> select dbms_standard.database_name from dual;

I don't know where this function is documented, but I ran into it after looking at the dbmsstdx.sql file in the rdbms/admin directory.

Frank Hubeny

Mike Streeton wrote:

> Is there a public view that gives the database name, I could use V$DATABASE
> but you need to be a DBA to get it. Are there any others?
>
> Many Thanks
>
> Mike
Received on Wed Jul 19 2000 - 00:00:00 CDT