Re: Read username from OS

Kiko wrote:

> Only valid for Oracle 9.2 and latter versions?
> My D.B. server has Oracle 8.0.6 versión.
> I try to run:
> SELECT sys_context('USERENV', 'USERNAME')
> FROM dual;
>
> with error.
>
> ----
>
> ¿Esta función solo es válida para la versión 9.2 de Oracle, y posteriores?
> Mi servidor Oracle tiene la 8.0.6.
>
> Intenté ejecutar :
> SELECT sys_context('USERENV', 'USERNAME')
> FROM dual;
>
> dándome error.
>
>
first try it with:

[Quoted] [Quoted] SELECT SYS_CONTEXT ('USERENV', 'CURRENT_USER') from dual; I don't think 'USERNAME' is a valid option.

If that doesn't work, then check out:
http://download-west.oracle.com/docs/cd/A64702_01/doc/index.htm and look for userenv

There aren't too many options for that one though. Received on Thu Feb 12 2004 - 16:16:51 CET