SQL Server logins
E937643
SQL Server logins are security principals that represent individual users or applications allowed to connect to a SQL Server instance and access its databases.
Observed surface forms (1)
| Surface form | Occurrences |
|---|---|
| SQL Server login | 0 |
Statements (50)
| Predicate | Object |
|---|---|
| instanceOf |
SQL Server security principal
ⓘ
authentication credential ⓘ |
| allows | connection to SQL Server instance ⓘ |
| alteredWith | ALTER LOGIN statement ⓘ |
| authenticatedBy | SQL Server Database Engine NERFINISHED ⓘ |
| canBe |
SQL Server Agent proxy owner
ⓘ
credential owner ⓘ disabled ⓘ enabled ⓘ endpoint owner ⓘ |
| canBelongTo | server role ⓘ |
| canBeMemberOf |
bulkadmin fixed server role
ⓘ
dbcreator fixed server role ⓘ diskadmin fixed server role ⓘ processadmin fixed server role ⓘ securityadmin fixed server role ⓘ serveradmin fixed server role ⓘ setupadmin fixed server role ⓘ sysadmin fixed server role ⓘ |
| canUse | contained database authentication (via contained users, not login) ⓘ |
| controls | access to SQL Server databases ⓘ |
| createdWith | CREATE LOGIN statement ⓘ |
| droppedWith | DROP LOGIN statement ⓘ |
| grants | server-level access ⓘ |
| hasMetadataIn | sys.sql_logins catalog view NERFINISHED ⓘ |
| hasProperty |
check expiration
ⓘ
check policy ⓘ default database ⓘ default language ⓘ enforce password expiration ⓘ enforce password policy ⓘ is disabled flag ⓘ must change password at next login ⓘ name ⓘ password (for SQL logins) ⓘ password policy settings ⓘ |
| hasType |
Azure Active Directory authentication login
ⓘ
SQL authentication login ⓘ Windows authentication login ⓘ |
| identifiedBy | SID ⓘ |
| isRequiredFor | non-contained database access ⓘ |
| listedIn | sys.server_principals catalog view ⓘ |
| mappedTo | database user ⓘ |
| represents |
application
ⓘ
user ⓘ |
| storedIn | master database ⓘ |
| supports |
login auditing
ⓘ
password complexity enforcement ⓘ password hashing ⓘ |
| usedIn | Microsoft SQL Server NERFINISHED ⓘ |
Referenced by (1)
Full triples — surface form annotated when it differs from this entity's canonical label.