SESSION_USER

PostgreSQL

SESSION_USER()

Example

SELECT SESSION_USER;

Output

   session_user
------------------
 postgres
(1 row)

Explanation

The SESSION_USER is a system information function in PostgreSQL. It returns the name of the current user executing the query. In the given example, it returns ‘postgres’ as currently the query is executed through this user.

SQL Server

SESSION_USER()

Example

SELECT SESSION_USER as 'Session User';

Output

Session User
---------------------------------
your_user_name

Explanation

The SESSION_USER function returns the user name of the current SQL Server session. In this example, your_user_name is the name of the current user.

Oracle

SESSION_USER

Example

SELECT SESSION_USER FROM DUAL;

Output

"SCOTT"

Explanation

In the given example, SESSION_USER is a function that returns the name of the currently authenticated user. The DUAL is a special one-row and one-column table present by default in all Oracle databases.