Re: Accessing UNIX user id from sql*plus

Look at the osuser column in v$session. You may need privileges granted, or a package wrapper to do this, but basic approach is:

    column osuser new_value m_osuser

    select osuser
    from V$session
    where audsid=userenv('sessionid');

    rem then use &m_osuser

--

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

eweber_at_bdo.com wrote in message <7fo2cj$6s0$1_at_nnrp1.dejanews.com>...
>How would I access a users unix id from sql*plus and then use it in my
>sql*plus environment?
>
Received on Thu Apr 22 1999 - 17:23:01 CDT