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.
|
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.
Reference
Security Catalog Views (Transact-SQL)
Catalog Views (Transact-SQL)
Other Resources
Principals (Database Engine)
Permissions Hierarchy (Database Engine)
Help and Information
Getting SQL Server 2008 Assistance