Difference between user and login_user ?

[OOelsner]

Hi,

what is the difference between
the use of the keyword user and
the select of the sys.login_user ?

Thanks in advance
O. Oelsner

[Shestakov]

USER --> this is oracle function that return USER_NAME (or USERNAME)

column sys.login_user --> not exists on oracle dictionary:

SQL> select table_name, COLUMN_NAME from dba_tab_columns where COLUMN_NAME like '%LOGIN_USER%';
no rows selected

login_user as function -->
function login_user return varchar2 ;
pragma interface (C, login_user);
pragma restrict_references (login_user, WNPS, RNPS, WNDS);

u can use in external procedures on c (c++).

[Edited by Shestakov on 05-13-2002 at 03:12 PM]

[lzsiga]

Hi,
what is the difference between
the use of the keyword user and
the select of the sys.login_user ?

The latter works through database links, e.g.

SQL> SELECT user, sys.login_user@dblink_name remuser FROM dual;

USER      REMUSER
--------- -------
SCOTT     SOMEONE

[Steve R Jones]

NOTE: This thread was started 22 YEARS ago.

[lzsiga]

> NOTE: This thread was started 22 YEARS ago.

Nonetheless, google still finds this topic if you search for "Oracle user vs sys.login_user", so it can be useful.