Skip to content

Latest commit

 

History

History
99 lines (71 loc) · 3.65 KB

suser-name-transact-sql.md

File metadata and controls

99 lines (71 loc) · 3.65 KB
Raw
title description author ms.author ms.reviewer ms.date ms.service ms.subservice ms.topic f1_keywords helpviewer_keywords dev_langs monikerRange
SUSER_NAME (Transact-SQL)
SUSER_NAME returns the login identification name of the user.
VanMSFT
vanto
randolphwest
10/04/2023
sql
t-sql
reference
SUSER_NAME
SUSER_NAME_TSQL
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
TSQL
= 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 ] )

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

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