REM  #*****************************************************
REM  # File Name: whoami.sql
REM  #
REM  # Purpose: Who you are logged onto the database as
REM  # Require: dbvs_version_audit table
REM  #
REM  #*****************************************************

set heading off feedback off

select max( user || '@' || SUBSTR(global_name,1,INSTR(global_name,'.')-1) || ' in DB version ' || DB_VERSION )
from global_name, dbvs_version_audit
/
set heading on feedback on