Get current user, session user and current schema by using sys_context : CONTEXT « SQL PLUS Session Environment « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. SQL PLUS Session Environment
3. CONTEXT

SQL> --
SQL>
SQL> create or replace procedure invoker_proc AUTHID CURRENT_USER as
  2  begin
  3      for x in ( select sys_context( 'userenv', 'current_user' ) current_user,
  4               sys_context( 'userenv', 'session_user' ) session_user,
  5               sys_context( 'userenv', 'current_schema' ) current_schema
  6          from dual )
  7      loop
  8          dbms_output.put_line( 'Current User:   ' || x.current_user );
  9          dbms_output.put_line( 'Session User:   ' || x.session_user );
 10          dbms_output.put_line( 'Current Schema: ' || x.current_schema );
 11      end loop;
 12  end;
 13  /

Procedure created.

SQL>