I'm using both 7.3.4 and 8.1.6 and was wondering if there was a select statement in 7.3.4 that would return the userid of the current session. I know the command below will give me the answer in 8.1.6 but it does not work in 7.3.4
'select sys_context('userenv','current_user') from dual;'
Thanks for your help
04-24-2002, 01:37 PM
It's been a while since I worked with 7.x, but I think there was a USERENV() function that you could get to return the username. Check the 7.x docs...
04-24-2002, 02:15 PM
select sid from v$session where audsid = USERENV('SESSIONID') ;