sys-login-token-transact-sql.md

title	sys.login_token (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	06/10/2016
ms.prod	sql
ms.prod_service	database-engine
ms.service
ms.component	system-catalog-views
ms.reviewer
ms.suite	sql
ms.technology	database-engine
ms.tgt_pltfrm
ms.topic	language-reference
f1_keywords	login_token_TSQL sys.login_token_TSQL sys.login_token login_token
dev_langs	TSQL
helpviewer_keywords	sys.login_token catalog view logins [SQL Server], security tokens tokens [SQL Server]
ms.assetid	86e06938-9d0a-44e5-99e2-55c8ef5f2f84
caps.latest.revision	28
author	edmacauley
ms.author	edmaca
manager	craigg
ms.workload	Inactive

sys.login_token (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]

Returns one row for every server principal that is part of the login token.

Column name	Data type	Description
principal_id	int	ID of the principal. This value is unique within server.
sid	varbinary(85)	Security identifier of the principal. If this is a Windows principal, sid = Windows SID. If the login is mapped to a certificate, sid = GUID from the certificate.
name	nvarchar(128)	Name of the principal. This value is unique within server.
type	nvarchar(128)	Description of principal type. All types are mapped to sid. The value can be one of the following: SQL LOGIN WINDOWS LOGIN WINDOWS GROUP SERVER ROLE LOGIN MAPPED TO CERTIFICATE LOGIN MAPPED TO ASYMMETRIC KEY CERTIFICATE ASYMMETRIC KEY
usage	nvarchar(128)	Indicates the principal participates in the evaluation of GRANT or DENY permissions, or serves as an authenticator. This value can be one of the following: GRANT OR DENY DENY ONLY AUTHENTICATOR

See Also

sys.user_token (Transact-SQL)
sys.server_principals (Transact-SQL)
sys.database_principals (Transact-SQL)
Principals (Database Engine)