Posted By

ceduard0 on 07/19/13

Tagged

Viewed 2347 times

Favorited by 0 user(s)

/ Published in: SQL

To get more information of the current session use this: DESC V$SESSION.

Note: Your user need a GRANT SELECT ON V_$SESSION TO username;

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

SELECT MACHINE,
       PROGRAM,
       OSUSER,
       USERNAME
 FROM V$SESSION 
WHERE sid=(SELECT sys_context('USERENV','SID') FROM dual);

Comment:

You need to login to post a comment.