Re: Read username from OS
From: Bricklen <bricklen-rem_at_yahoo.comz>
Date: Thu, 12 Feb 2004 15:18:07 GMT
Message-ID: <POMWb.39241$964.7370_at_edtnps84>
> first try it with:
>
> 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.
Date: Thu, 12 Feb 2004 15:18:07 GMT
Message-ID: <POMWb.39241$964.7370_at_edtnps84>
Bricklen wrote:
>>
> first try it with:
>
> 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.
Alternatively, try it with OS_USER if that's what you're looking for:
SELECT SYS_CONTEXT ('USERENV', 'OS_USER') from dual; Received on Thu Feb 12 2004 - 16:18:07 CET