# User: dbo

## Properties

Property | Value
--- | ---
Name | dbo
Principal ID | 1
Type | Windows User
Default Schema | dbo
SID | x01050000000000051500000025B2C65A6DE3BF7F151D61F3F4010000
Login | PROJECTENVISION\Administrator
Modify Date | 8/8/2010 5:21:41 PM
Creation Date | 4/8/2003 9:10:42 AM

## Extended Properties

No extended properties defined.

## Objects

Type Desc | Schema Name | Name
--- | --- | ---
Assembly |  | KrystianUDT
Assembly |  | TestAssembly
Asymetric Key |  | AsymetricTest
Asymetric Key |  | PacificSales09
Asymetric Key |  | PacificSales19
Certificate |  | Shipping04
Certificate |  | Shipping11
Certificate |  | Shipping19
Contract |  | DEFAULT
Contract |  | http://schemas.microsoft.com/SQL/Notifications/PostEventNotification
Contract |  | http://schemas.microsoft.com/SQL/Notifications/PostQueryNotification
Contract |  | http://schemas.microsoft.com/SQL/ServiceBroker/BrokerConfigurationNotice
Contract |  | http://schemas.microsoft.com/SQL/ServiceBroker/ServiceDiagnostic
Contract |  | http://schemas.microsoft.com/SQL/ServiceBroker/ServiceEcho
Full Text Catalog |  | AW2008FullTextCatalog
Fulltext Stoplist |  | myStoplist
Message Type |  | //Adventure-Works.com/Expenses/ExpenseApprovedOrDenied
Message Type |  | //Adventure-Works.com/Expenses/SubmitExpense
Message Type |  | DEFAULT
Message Type |  | http://schemas.microsoft.com/SQL/Notifications/EventNotification
Message Type |  | http://schemas.microsoft.com/SQL/Notifications/QueryNotification
Message Type |  | http://schemas.microsoft.com/SQL/ServiceBroker/BrokerConfigurationNotice/FailedRemoteServiceBinding
Message Type |  | http://schemas.microsoft.com/SQL/ServiceBroker/BrokerConfigurationNotice/FailedRoute
Message Type |  | http://schemas.microsoft.com/SQL/ServiceBroker/BrokerConfigurationNotice/MissingRemoteServiceBinding
Message Type |  | http://schemas.microsoft.com/SQL/ServiceBroker/BrokerConfigurationNotice/MissingRoute
Message Type |  | http://schemas.microsoft.com/SQL/ServiceBroker/DialogTimer
Message Type |  | http://schemas.microsoft.com/SQL/ServiceBroker/EndDialog
Message Type |  | http://schemas.microsoft.com/SQL/ServiceBroker/Error
Message Type |  | http://schemas.microsoft.com/SQL/ServiceBroker/ServiceDiagnostic/Description
Message Type |  | http://schemas.microsoft.com/SQL/ServiceBroker/ServiceDiagnostic/Query
Message Type |  | http://schemas.microsoft.com/SQL/ServiceBroker/ServiceDiagnostic/Status
Message Type |  | http://schemas.microsoft.com/SQL/ServiceBroker/ServiceEcho/Echo
Role |  | db_accessadmin
Role |  | db_backupoperator
Role |  | db_datareader
Role |  | db_datawriter
Role |  | db_ddladmin
Role |  | db_denydatareader
Role |  | db_denydatawriter
Role |  | db_owner
Role |  | db_securityadmin
Role |  | public
Routes |  | AutoCreatedLocal
Schema |  | dbo
Schema |  | HumanResources
Schema |  | Person
Schema |  | Production
Schema |  | Purchasing
Schema |  | Sales
Service |  | http://schemas.microsoft.com/SQL/Notifications/EventNotificationService
Service |  | http://schemas.microsoft.com/SQL/Notifications/QueryNotificationService
Service |  | http://schemas.microsoft.com/SQL/ServiceBroker/ServiceBroker
Symetric Key |  | ##MS_DatabaseMasterKey##
Symetric Key |  | JanainaKey09

## Object Level Permissions

No explicit permissions granted to that database principal

## Column Level Permissions

No explicit column permissions granted to this database principal

## Roles

Principal ID | Name
--- | ---
16384 | db_owner
| public

## SQL

Script
CREATE USER [dbo] FOR LOGIN [PROJECTENVISION\Administrator] WITH DEFAULT_SCHEMA=[dbo] sys.sp_addrolemember @rolename = N'db_owner', @membername = N'dbo'

#### See also

List of Users