Re: Read username from OS
From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Thu, 12 Feb 2004 15:28:54 -0000
Message-ID: <402b9bb6$0$10334$ed9e5944_at_reading.news.pipex.net>
Date: Thu, 12 Feb 2004 15:28:54 -0000
Message-ID: <402b9bb6$0$10334$ed9e5944_at_reading.news.pipex.net>
I don't believe that sys_context was valid back in 8.0.6, just USERENV.
-- Niall Litchfield Oracle DBA Audit Commission UK "Bricklen" <bricklen-rem_at_yahoo.comz> wrote in message news:POMWb.39241$964.7370_at_edtnps84...Received on Thu Feb 12 2004 - 16:28:54 CET
> 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;