sys.server_principals (Transact-SQL)

Contains a row for every server-level principal.

Column name

Data type

Description

name

sysname

Name of the principal. Is unique within a server.

principal_id

int

ID number of the Principal. Is unique within a server.

sid

varbinary(85)

SID (Security-IDentifier) of the principal. If Windows principal, then it matches Windows SID.

type

char(1)

Principal type:

S = SQL login

U = Windows login

G = Windows group

R = Server role

C = Login mapped to a certificate

K = Login mapped to an asymmetric key

type_desc

nvarchar(60)

Description of the principal type:

SQL_LOGIN

WINDOWS_LOGIN

WINDOWS_GROUP

SERVER_ROLE

CERTIFICATE_MAPPED_LOGIN

ASYMMETRIC_KEY_MAPPED_LOGIN

is_disabled

int

1 = Login is disabled.

create_date

datetime

Time at which the principal was created.

modify_date

datetime

Time at which the principal definition was last modified.

default_database_name

sysname

Default database for this principal.

default_language_name

sysname

Default language for this principal.

credential_id

int

ID of a credential associated with this principal. If no credential is associated with this principal, credential_id will be NULL.

Permissions

In SQL Server 2005 and later versions, the visibility of the metadata in catalog views is limited to securables that a user either owns or on which the user has been granted some permission. For more information, see Metadata Visibility Configuration.