Posted By

ceduard0 on 07/19/13


Tagged

PLSQL DBA Developing


Versions (?)

How to get MACHINE name, PROGRAM name, operative system USER and the USERNAME related to the current Oracle Database Session


 / 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;

  1. SELECT MACHINE,
  2. PROGRAM,
  3. OSUSER,
  4. USERNAME
  5. FROM V$SESSION
  6. WHERE sid=(SELECT sys_context('USERENV','SID') FROM dual);

Report this snippet  

You need to login to post a comment.