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

Revision: 64284

at July 19, 2013 01:54 by ceduard0

Initial Code

select MACHINE,
       PROGRAM,
       OSUSER,
       USERNAME
 from V$SESSION 
where sid=(select sys_context('USERENV','SID') from dual);

Initial URL

Initial Description

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;

Initial Title

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

Initial Tags

Initial Language

SQL