Database permissions

The following tables list the accounts to be added to the specified roles on the computers that are running SQL Server. By default, the database names begin with StarterSite. However, you may have specified different database names when you unpacked your site.

Database Account: CatalogWebSvc

Database Roles
MSCS_Admin admin_reader_role, admin_cache_poller_role
MSCS_CatalogScratch db_datareader, db_datawriter, db_ddladmin
StarterSite_ProductCatalog ctlg_CatalogWriterRole, db_datareader, db_datawriter, db_ddladmin, db_securityadmin, Inventory_ReaderRole, Inventory_WriterRole

Database Account: MarketingWebSvc

Database Roles
MSCS_Admin admin_reader_role, admin_cache_poller_role
StarterSite_Marketing db_datareader, db_datawriter, db_ddladmin
StarterSite_MarketingListsc db_owner
StarterSite_ProductCatalog ctlg_catalogReaderRole
StarterSite_Profiles Profile_Reader, Profile_Schema_Reader, ctlg_catalogReaderRole

Database Account: OrdersWebSvc

Database Roles
MSCS_Admin admin_reader_role, admin_cache_poller_role
MSCS_CatalogScratch db_datareader, db_datawriter, db_ddladmin
StarterSite_Marketing mktg_runtime_role
StarterSite_ProductCatalog ctlg_catalogReaderRole, Inventory_ReaderRole
StarterSite_Profiles Profile_Reader, Profile_Schema_Reader
StarterSite_TransactionConfig Orders_Management
StarterSite_Transactions Orders_Management, Orders_Runtime

Database Account: ProfilesWebSvc

Database Roles
MSCS_Admin admin_reader_role, admin_cache_poller_role
StarterSite_Profiles Profile_Schema_Manager, Profile_Runtime, ctlg_CatalogWriterRole

Database Account: RunTimeUser

Database Roles
MSCS_Admin admin_reader_role, admin_cache_poller_role
MSCS_CatalogScratch db_datareader, db_datawriter, db_ddladmin
StarterSite_Marketing mktg_runtime_role
StarterSite_MarketingLists db_datareader
StarterSite_ProductCatalog ctlg_catalogReaderRole, ctlg_CatalogWriterRole, Inventory_RuntimeRole, db_ddladmin, db_securityadmin, Inventory_ReaderRole, Inventory_WriterRole, db_datareader, db_datawriter
StarterSite_Profiles Profile_Schema_Reader, Profile_Runtime
StarterSite_TransactionConfig Orders_Runtime
StarterSite_Transactions Orders_Runtime

Database Account: CSStageSvc

Database Roles
MSCS_Admin admin_reader_role
MSCS_CatalogScratch db_datareader, db_datawriter, db_ddladmin
StarterSite_Marketing db_ddladmin, mktg_staging_role
StarterSite_MarketingLists db_datareader
StarterSite_ProductCatalog ctlg_CatalogWriterRole, db_datareader, db_datawriter, db_ddladmin, db_securityadmin, Inventory_ReaderRole, Inventory_WriterRole
StarterSite_Profiles Profile_Schema_Manager
StarterSite_TransactionConfig Orders_Management

Database Account: <CS Staging User>

Database Roles
MSCS_Admin db_datareader
MSCS_CatalogScratch db_datareader, db_datawriter, db_ddladmin
StarterSite_ProductCatalog ctlg_CatalogWriterRole, Inventory_ReaderRoles