Current_user function is an security function and return the name of the current user connected.

CURRENT_USER Syntax:

CURRENT_USER

CURRENT_USER Example:

select CURRENT_USER as Username;

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