Login: PROJECTENVISION\krystian.zieja Login: PROJECTENVISION\krystian.zieja| Property | Value |
|---|---|
| Login Name | PROJECTENVISION\krystian.zieja |
| Principal ID | 263 |
| Login Type | WINDOWS LOGIN |
| Enabled |
|
| SID | x01050000000000051500000025B2C65A6DE3BF7F151D61F360040000 |
| Default Database | master |
| Default Language | us_english |
| Default language friendly name | English |
| Enforce Password Policy |
|
| Enforce Password Expiration |
|
| Permission to connect to database engine |
|
| Mapped to certificate | |
| Mapped to asymmetric key | |
| System Object |
|
| Last Modify Time | 10/31/2010 4:02:10 PM |
| Create Time | 8/2/2010 2:48:04 AM |
| Database Name | Username | Type |
|---|---|---|
| cart2 | dbo | WINDOWS USER |
| NOP2 | dbo | WINDOWS USER |
| CCApp | dbo | WINDOWS USER |
| InfrastructureMonitor | dbo | WINDOWS USER |
| OrderTracking | dbo | WINDOWS USER |
| PLPKDATATMPARCH | dbo | WINDOWS USER |
| NOP | dbo | WINDOWS USER |
| DATA | dbo | WINDOWS USER |
| ireusable | dbo | WINDOWS USER |
| SqlDocLogs | dbo | WINDOWS USER |
| polymon | dbo | WINDOWS USER |
| SportStore | dbo | WINDOWS USER |
| store | dbo | WINDOWS USER |
| BNFDatabase | dbo | WINDOWS USER |
| ReportServerTempDB | dbo | WINDOWS USER |
| ReportServer | dbo | WINDOWS USER |
| SharePoint_Config | dbo | WINDOWS USER |
| msinvestment | dbo | WINDOWS USER |
| SharePoint_AdminContent_f381ba2b-72ff-40c5-b55b-2a299cd49c3d | dbo | WINDOWS USER |
| Role Name |
|---|
| sysadmin |
| 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 | ||||
| External Access |
| Script |
|---|
| CREATE LOGIN [PROJECTENVISION\krystian.zieja] FROM WINDOWS WITH DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english] |