This function exists only in Oracle8i contrary to global_name view
that exists since Oracle7.
They give the same result: the value of the property GLOBAL_DB_NAME
(look at select value$ from sys.props$ where name = 'GLOBAL_DB_NAME';).
--
Cheers
Michel
Frank Hubeny <fhubeny_at_ntsource.com> a écrit dans le message : 397536ED.6E715597_at_ntsource.com...
> 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;
>
> <Database Name Displayed>
>
> 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
