SESSION_USER
Returns a VARCHAR containing the name of the user who initiated the current database session.
Behavior Type
Syntax
SESSION_USER()
Notes
- The SESSION_USER function does not require parentheses.
- SESSION_USER is equivalent to CURRENT_USER, USER, and USERNAME.
Examples
=> SELECT SESSION_USER(); session_user -------------- dbadmin (1 row)
The following command returns the same results without the parentheses:
=> SELECT SESSION_USER; session_user -------------- dbadmin (1 row)