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 |