Skip to content

suser-name-transact-sql.md

Latest commit

 

History

History
97 lines (70 loc) · 3.43 KB

suser-name-transact-sql.md

File metadata and controls

97 lines (70 loc) · 3.43 KB
title SUSER_NAME (Transact-SQL)
description SUSER_NAME returns the login identification name of the user.
author VanMSFT
ms.author vanto
ms.reviewer randolphwest
ms.date 10/04/2023
ms.service sql
ms.subservice t-sql
ms.topic reference
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 || =fabric

SUSER_NAME (Transact-SQL)

[!INCLUDE SQL Server Azure SQL Managed Instance fabricse fabricdw]

Returns the login identification name of the user.

:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: Transact-SQL syntax conventions

Syntax

SUSER_NAME ( [ server_user_id ] )

Arguments

server_user_id

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 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 returns NULL.

Return type

nvarchar(128)

Remarks

SUSER_NAME returns a login name only for a login that has an entry in the sys.server_principals or sys.sql_logins catalog views.

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

A. Use SUSER_NAME

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

SELECT SUSER_NAME(1);

B. Use SUSER_NAME without an ID

The following example finds the name of the current user without specifying an ID.

SELECT SUSER_NAME();  
GO

In SQL Server, here is the result set for a Microsoft Entra ID authenticated login:

contoso\username

In Azure SQL Database and Microsoft Fabric, here is the result set for a Microsoft Entra ID authenticated login:

username@contoso.com

Related content