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.

If SYS_CONTEXT is not available in 8.0.6 ... first choice would be to upgrade to something supported this century. If not possible look at columns in v_$session.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)