Tricky! Getting current OSUSER from V$SESSION

[pando]

select osuser
from v$session
where audsid=userenv('SESSIONID');

dont try with user sys though

this works as well
select sys_context('USERENV', 'OS_USER') from dual;

this works with sys

[Edited by pando on 06-24-2002 at 05:02 PM]