Who deployed it?

[rsantmyer]

for no-privilege capture:

SELECT
    SYS_CONTEXT('USERENV', 'SESSION_USER')      AS session_user,
    SYS_CONTEXT('USERENV', 'CURRENT_SCHEMA')    AS current_schema,
    SYS_CONTEXT('USERENV', 'CURRENT_USER')      AS current_user,
    SYS_CONTEXT('USERENV', 'PROXY_USER')        AS proxy_user,
    SYS_CONTEXT('USERENV', 'OS_USER')           AS os_user,
    SYS_CONTEXT('USERENV', 'HOST')              AS host,
    SYS_CONTEXT('USERENV', 'IP_ADDRESS')        AS ip_address,
    SYS_CONTEXT('USERENV', 'MODULE')            AS module,
    SYS_CONTEXT('USERENV', 'ACTION')            AS action,
    SYS_CONTEXT('USERENV', 'CLIENT_IDENTIFIER') AS client_identifier
FROM dual;

session row:

SELECT
    s.username,
    s.schemaname,
    s.osuser,
    s.machine,
    s.program,
    s.module,
    s.action,
    s.client_identifier,
    s.terminal,
    s.logon_time
FROM v$session s
WHERE s.audsid = SYS_CONTEXT('USERENV', 'SESSIONID');

RAC:

SELECT
    s.inst_id,
    s.username,
    s.schemaname,
    s.osuser,
    s.machine,
    s.program,
    s.module,
    s.action,
    s.client_identifier,
    s.terminal,
    s.logon_time
FROM gv$session s
WHERE s.inst_id = SYS_CONTEXT('USERENV', 'INSTANCE')
  AND s.audsid  = SYS_CONTEXT('USERENV', 'SESSIONID');

[rsantmyer]

proxy user:

SELECT
    SYS_CONTEXT('USERENV', 'SESSION_USER') AS session_user,
    SYS_CONTEXT('USERENV', 'PROXY_USER')   AS proxy_user,
    SYS_CONTEXT('USERENV', 'CURRENT_USER') AS current_user,
    SYS_CONTEXT('USERENV', 'CURRENT_SCHEMA') AS current_schema
FROM dual;