suser-name-transact-sql.md

title	SUSER_NAME (Transact-SQL)
description	SUSER_NAME (Transact-SQL)
author	VanMSFT
ms.author	vanto
ms.reviewer
ms.date	12/12/2020
ms.prod	sql
ms.prod_service	synapse-analytics, sql-database
ms.technology	t-sql
ms.topic	reference
ms.custom
f1_keywords	SUSER_NAME SUSER_NAME_TSQL
helpviewer_keywords	security identification names [SQL Server] logins [SQL Server], users identification names for logins [SQL Server] users [SQL Server], logins SUSER_NAME function logins [SQL Server], names names [SQL Server], logins
dev_langs	TSQL
monikerRange	= azure-sqldw-latest || >= sql-server-2016 || >= sql-server-linux-2017 || = azuresqldb-mi-current

SUSER_NAME (Transact-SQL)

[!INCLUDE SQL Server Azure SQL Managed Instance]

Returns the login identification name of the user.

Transact-SQL Syntax Conventions

Syntax

SUSER_NAME ( [ server_user_id ] )   

[!INCLUDEsql-server-tsql-previous-offline-documentation]

Arguments

server_user_id
Is the login identification number of the user. server_user_id, which is optional, is int. server_user_id can be the login identification number of any [!INCLUDEssNoVersion] login or [!INCLUDEmsCoName] Windows user or group that has permission to connect to an instance of [!INCLUDEssNoVersion]. When server_user_id isn't specified, the login identification name for the current user is returned. If the parameter contains the word NULL, it will return NULL.

Return Types

nvarchar(128)

Remarks

In [!INCLUDEssNoVersion] version 7.0, the security identification number (SID) replaced the server user identification number (SUID).

SUSER_NAME returns a login name only for a login that has an entry in the syslogins system table.

SUSER_NAME can be used in a select list, in a WHERE clause, and anywhere an expression is allowed. Use parentheses after SUSER_NAME, even if no parameter is specified.

Note

Although the SUSER_NAME function is supported on Azure SQL Database, using Execute as with SUSER_NAME is not supported on Azure SQL Database.

Examples

The following example returns the login identification name of the user with a login identification number of 1.

SELECT SUSER_NAME(1);  

See Also

SUSER_ID (Transact-SQL)
Principals (Database Engine)