ora_context_info.sql

set lines 250
set pages 100
col instance_name for a25
col con_name for a25
col database_role for a25
col session_user for a25
col current_user for a25
col current_schema for a25
col proxy_user for a25
col authenticated_identity for a25
col authentication_method for a25
select sys_context('userenv','instance_name') as instance_name,
       sys_context('userenv','con_name') as con_name,
       sys_context('userenv','database_role') as database_role,
       sys_context('userenv','session_user') as session_user,
       sys_context('userenv','current_user') as current_user,
       sys_context('userenv','current_schema') as current_schema,
       sys_context('userenv','proxy_user') as proxy_user,
       sys_context('userenv','authenticated_identity') as authenticated_identity,
       sys_context('userenv','authentication_method') as authentication_method from dual;

set lines 250
set pages 100
col instance_name for a25
col con_name for a25
col database_role for a25
col session_user for a25
col current_user for a25
col current_schema for a25
col proxy_user for a25
col authenticated_identity for a25
col authentication_method for a25
select sys_context('userenv','instance_name') as instance_name,
       sys_context('userenv','con_name') as con_name,
       sys_context('userenv','database_role') as database_role,
       sys_context('userenv','session_user') as session_user,
       sys_context('userenv','current_user') as current_user,
       sys_context('userenv','current_schema') as current_schema,
       sys_context('userenv','proxy_user') as proxy_user,
       sys_context('userenv','authenticated_identity') as authenticated_identity,
       sys_context('userenv','authentication_method') as authentication_method from dual;