sys.user_token (Transact-SQL)

sys.user_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 database principal that is part of the user token in SQL Server.

Column nameData typeDescription
principal_idintID of the principal. The value is unique within database.
sidvarbinary(85)Security identifier of the principal if the principal is defined external to the database. For example, this can be a SQL Server login, Windows login, Windows Group login, or a login mapped to a certificate, otherwise, this value is NULL.
namenvarchar (128)Name of the principal. The value is unique within database.
typenvarchar (128)Description of principal type. All types are mapped to sid. The value can be one of the following:

SQL USER

WINDOWS LOGIN

WINDOWS GROUP

ROLE

APPLICATION ROLE

DATABASE ROLE

USER MAPPED TO CERTIFICATE

USER 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.login_token (Transact-SQL)
sys.server_principals (Transact-SQL)
sys.database_principals (Transact-SQL)
Principals (Database Engine)

Community Additions

ADD
Show:
© 2016 Microsoft