sys.login_token (Transact-SQL)

sys.login_token (Transact-SQL)

 

Updated: June 10, 2016

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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

Column nameData typeDescription
principal_idintID of the principal. This value is unique within server.
sidvarbinary(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.
namenvarchar(128)Name of the principal. This value is unique within server.
typenvarchar(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
usagenvarchar(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

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

Community Additions

ADD
Show:
© 2016 Microsoft