Oracle SQL: the Essential Reference

USER

USER

Returns the current username. Normally, USER returns the username used to log into the database. When invoked from within a stored procedure or function, however, USER returns the name of the procedure or function's owner. USER is also known as a pseudo-column. See Chapter 1 for more information.

When invoked from within a trigger, USER returns the login username.

Example

SQL> SELECT USER FROM dual;

USER
------------------------------
SYSTEM