.png){kind=spacer}
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. |
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.
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.
- 6/27/2011
- Paw Jershauge
- 6/27/2011
- Paw Jershauge
