PLSQL, SQL*PLUS get current username?

Question

I know that the show user command return: USER is "SCOTT"

But is it possible in a sql query or in a plsql script to only get the username of the current user and store it in a variable?

Under

select user from dual – Gyve

Answer 1

The USER built-in function may be used.

DECLARE
  v VARCHAR2(30);
BEGIN
  v := USER;
END;

Yazzie

Notice this calls STANDARD.USER(), which produces a PL/SQL to SQL context switch. Better use this approach instead. – Jainism

Answer 2

SYS_CONTEXT( 'USERENV', 'CURRENT_USER' )

Marcomarconi

Deprecated as of 10g, better to use 'SESSION_USER' instead: docs.oracle.com/cd/B19306_01/server.102/b14200/functions165.htm – Disconnect

Answer 3

fnd_profile.value('USERNAME')
fnd_profile.value('USER_ID')
fnd_flobal.user_id

these can be used to get the user details

Rhiamon

fnd_profile is not a standard Oracle package. Can you give a link to the Oracle manual? – Gyve

refer this for more info link – Rhiamon

That's Oracle E-Business Suite. That is something different than Oracle's database product. You can't use those functions in SQL or PL/SQL through SQL*Plus – Gyve

Answer 4

1. SQL> show user; USER is "SCOTT"

or

2. SQL> select user from dual;

USER

SCOTT

Chazan