SESSION_USER (TSQL Function)

Returns the name of the current user in the current database.

Syntax

SESSION_USER

Return Types

Returns varchar.

Remarks

The functions SESSION_USER, CURRENT_USER, USER and USER_NAME() return the same result.

Examples

PRINT SESSION_USER;
PRINT CURRENT_USER;
PRINT USER;
PRINT USER_NAME();

The result is:

john
john
john
john