Re: Read username from OS
From: Bricklen <bricklen-rem_at_yahoo.comz>
Date: Thu, 12 Feb 2004 16:46:51 GMT
Message-ID: <%5OWb.39337$964.24421_at_edtnps84>
Date: Thu, 12 Feb 2004 16:46:51 GMT
Message-ID: <%5OWb.39337$964.24421_at_edtnps84>
Kiko wrote:
> SQLWKS> SELECT SYS_CONTEXT ('USERENV', 'CURRENT_USER') from dual;
> SELECT SYS_CONTEXT ('USERENV', 'CURRENT_USER') from dual
> *
> ORA-00904: nombre de columna no válido - I translate : (Column name not
> valid)
> SQLWKS>
> SQLWKS> SELECT SYS_CONTEXT ('USERENV', 'OS_USER') from dual;
> SELECT SYS_CONTEXT ('USERENV', 'OS_USER') from dual
> *
> ORA-00904: nombre de columna no válido
>
>
>
read the rest of my post (and Niall's) about USERENV, and follow the
link I provided you.
Received on Thu Feb 12 2004 - 17:46:51 CET