Mike Kutz wrote:
Just for Reference: If you use APEX ( 5.0+ ), you would access APEX$SESSION and APP_USER
Just for reference. This would not work well in an Apex environment. You need to switch the order of the contexts around.
coalesce(sys_context('APEX$SESSION','APP_USER')--APEX5.0+ ,sys_context('userenv','client_identifier')--someotherapplication ,sys_context('userenv','session_user'))--OracleUSER(egSQL*Plus/SQL*Developer)
Apex sets the client_identifier as APP_USER:SESSION_ID (might be the other way round). So you would always store something like "MIKE:1234567890".