user key icon 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