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
Any login can see their own login name, the system logins, and the fixed server roles. To see other logins, requires ALTER ANY LOGIN, or a permission on the login. To see user-defined server roles, requires ALTER ANY SERVER ROLE, or membership in the role.
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.