Re: Read username from OS
From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Fri, 13 Feb 2004 14:30:46 -0000
Message-ID: <402cdf96$0$7074$ed9e5944_at_reading.news.pipex.net>
Date: Fri, 13 Feb 2004 14:30:46 -0000
Message-ID: <402cdf96$0$7074$ed9e5944_at_reading.news.pipex.net>
[Quoted] as it turns out Oracle8 USERENV doesn't identify the osuser anyway.
-- Niall Litchfield Oracle DBA Audit Commission UK "Bricklen" <bricklen-rem_at_yahoo.comz> wrote in message news:%5OWb.39337$964.24421_at_edtnps84...Received on Fri Feb 13 2004 - 15:30:46 CET
> 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.