Login: ##MS_PolicyTsqlExecutionLogin## Login: ##MS_PolicyTsqlExecutionLogin##| Property | Value |
|---|---|
| Login Name | ##MS_PolicyTsqlExecutionLogin## |
| Principal ID | 257 |
| Login Type | SQL LOGIN |
| Enabled |
|
| SID | x8F651FE8547A4644A0C06CA83723A876 |
| 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 | 7/30/2010 11:34:46 AM |
| Create Time | 7/9/2008 4:50:20 PM |
| Database Name | Username | Type |
|---|---|---|
| msdb | ##MS_PolicyTsqlExecutionLogin## | SQL USER |
| 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 | sa |
|
||
| 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 [##MS_PolicyTsqlExecutionLogin##] WITH PASSWORD=************************, DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english], CHECK_EXPIRATION=OFF, CHECK_POLICY=ON ALTER LOGIN [##MS_PolicyTsqlExecutionLogin##] DISABLE |