The T-SQL Session_User is an security function and return the session user.

Session_User Syntax:

SESSION_USER

Session_User Example:

select SESSION_USER as 'Session_user';

See also: T-SQL Functions -> CURRENT_USER | ORIGINAL_LOGIN | SYSTEM_USER | USER_NAME