SQL Server SESSION_USER Function

Return the user name of the current user:

SELECT SESSION_USER;

Definition and Usage

The SESSION_USER function returns the name of the current user in the SQL Server database.

SESSION_USER

Works in:	SQL Server (starting with 2008), Azure SQL Database, Azure SQL Data Warehouse, Parallel Data Warehouse