sys.server_principals

compatibility

#compatibility#catalog-view

Description

Returns the login identification number of the user. Is the login name of the user. is specified as can be any SQL Server login or Windows user or group that has permission to connect to an instance of SQL Server. If is not specified, the login identification number for the current user is returned. If the parameter contains the word NULL will return NULL. SUSER_ID returns an identification number only for logins that have been explicitly provisioned inside SQL Server. This ID is used within SQL Server to track ownership and permissions. This ID is not equivalent to the SID of the login that is returned by SUSER_SID. If is a SQL Server Starting with SQL Server 2005 (9.x), SUSER_ID returns the value listed as ## Syntax

SELECT pr.principal_id, pr.name, pr.type_desc,
pe.state_desc, pe.permission_name

ON pe.grantee_principal_id = pr.principal_id;

Permissions

Remarks

Returns the login identification number of the user.

Is the login name of the user.

is specified as

is implicitly

converted to

can be any SQL Server login or Windows user or group that has

permission to connect to an instance of SQL Server. If

is not specified, the login

identification number for the current user is returned. If the parameter contains the word NULL

will return NULL.

SUSER_ID returns an identification number only for logins that have been explicitly provisioned

inside SQL Server. This ID is used within SQL Server to track ownership and permissions. This ID

is not equivalent to the SID of the login that is returned by SUSER_SID. If

is a SQL Server

Starting with SQL Server 2005 (9.x), SUSER_ID returns the value listed as

catalog view.

Analytics Platform System (PDW)

SQL analytics endpoint in

Microsoft Fabric

Warehouse in Microsoft Fabric

Returns the login name associated with a security identification number (SID).

The optional login security identification number.

server_user_sid

can be the security identification number of any SQL Server login or Microsoft

Windows user or group. Refer to the

catalog views. If

server_user_sid

isn’t specified, information about the current user is returned. If

the parameter contains the word

server_user_sid

is not supported on Azure SQL Database or SQL database in Microsoft Fabric.

can be used as a

constraint in either

can be used in a select list, in a

clause, and anywhere an expression is

must always be followed by parentheses, even if no parameter is

Examples

Example 1

SELECT pr.principal_id, pr.name, pr.type_desc,
pe.state_desc, pe.permission_name
FROM sys.server_principals AS pr
JOIN sys.server_permissions AS pe
ON pe.grantee_principal_id = pr.principal_id;

Example 2

master

Example 3

sys.server_principals

Example 4

sys.sql_logins

Example 5

SELECT pr.principal_id, pr.name, pr.type_desc,
pe.state_desc, pe.permission_name
FROM sys.server_principals
AS pr
JOIN sys.server_permissions
AS pe
ON pe.grantee_principal_id = pr.principal_id;