I need some assistance.

We are currently using proxy authentication with BI Publisher (Reporting tool) to display reports to end users.
When looking through Enterprise manager (with DBA privileges) we can identify the SID executing a SQL report, but are unable to specifically identify the end user executing a particular SQL report.

How does a dba obtain the authenticated identify with only a SID?

Using the v$session table we only see the proxy user name in the USERNAME column.
-> select SID, USERNAME from v$session where audsid=sys_context('userenv','SESSIONID');
--> Gives SID = 1234; USERNAME = "Proxy"

We need to see something like SYS_CONTEXT ('USERENV','AUTHENTICATED_IDENTITY').
-> select SYS_CONTEXT ('USERENV','AUTHENTICATED_IDENTITY') from dual;
--> Gives "Peter"

The Sys_context functionality contains all the information I need.
Is there a way to join from the v$session to the "Sys_Context" information and get all of the additional Sys_context information that is not available in v$session table?

And/or is there a configuration within enterprise manager to show the authenticated identity information?

Thanks for you help
Peter

SQL> select p.username proxy,
  2         u.username uname,
  3             u.sessionid,
  4         u.proxy_sessionid
  5    from dba_audit_trail u, dba_audit_trail p
  6   where u.proxy_sessionid = p.sessionid
  7     and p.action_name = 'PROXY AUTHENTICATION ONLY'
  8  /

PROXY     UNAME  SESSIONID PROXY_SESSIONID
--------- ----- ---------- ---------------
A         SCOTT    1831304         1831303
A         SCOTT    1831304         1831303
OPS$TKYTE SCOTT    1831313         1831312

3 rows selected.

connect ops$tkyte[scott]/foobar;