-
Hi,
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
Moff.
-
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...
Jeff Hunter
-
select sid from v$session where audsid = USERENV('SESSIONID') ;
Thanks
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|