Database permissions

Current version: 8.2

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

Do you have some feedback for us?

If you have suggestions for improving this article,