Applies To: SQL Server 2014, SQL Server 2016 Preview
Returns one row for every server principal that is part of the login token.
Applies to: SQL Server (SQL Server 2008 through current version).
ID of the principal. This value is unique within server.
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 of the principal. This value is unique within server.
Description of principal type. All types are mapped to sid. The value can be one of the following:
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: