Login: login_test Login: login_test| Property | Value |
|---|---|
| Login Name | login_test |
| Principal ID | 265 |
| Login Type | SQL LOGIN |
| Enabled |
|
| SID | x6512797FB1F54E4FA8C281C87C2B333A |
| Default Database | master |
| Default Language | us_english |
| Default language friendly name | English |
| Enforce Password Policy |
|
| Enforce Password Expiration |
|
| Password Expired |
|
| User must change password at next login |
|
| Login is locked out |
|
| Permission to connect to database engine |
|
| Mapped to certificate | |
| Mapped to asymmetric key | |
| System Object |
|
| Last Modify Time | 9/19/2010 3:28:26 AM |
| Create Time | 9/19/2010 3:28:26 AM |
| Permission | Grantor | Grant | With Grant | Deny |
|---|---|---|---|---|
| Administer Bulk Operations | ||||
| Alter | ||||
| Alter Any Credential | ||||
| Alter Any Connection | ||||
| Alter Any Database | ||||
| Alter Any Event Notification | ||||
| Alter Any Endpoint | ||||
| Alter Any Login | ||||
| Alter Any Linked Server | ||||
| Alter Resources | ||||
| Alter Server State | ||||
| Alter Settings | ||||
| Alter Trace | ||||
| Authenticate Server | ||||
| Control Server | ||||
| Control | ||||
| Create Any Database | ||||
| Create DDL Event Notification | ||||
| Create Endpoint | ||||
| Create Trace Event Notification | ||||
| Impersonate | ||||
| Shutdown | ||||
| Take Ownership | ||||
| View Definition | ||||
| View Any Definition | ||||
| View Any Database | ||||
| View Server State | sa |
|
||
| External Access |
| Script |
|---|
| /* For security reasons the login is created disabled and with a random password. */
CREATE LOGIN [login_test] WITH PASSWORD=************************, DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english], CHECK_EXPIRATION=ON, CHECK_POLICY=ON ALTER LOGIN [login_test] DISABLE |