SQL Server USER_NAME() Function

Return the database user name (will return the current user since no id is specified):

SELECT USER_NAME();

Definition and Usage

The USER_NAME() function returns the database user name based on the specified id.

If no id is specified, this function will return the name of the current user.

USER_NAME( id_number)

Parameter	Description
id_number	Optional. The id number of a user in the database

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

Return the database user name with id 1:

SELECT USER_NAME(1);