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.