Database permissions
SQL Database Account, Database, and Database Role User Mapping
The following table lists the accounts on the computers that are running SQL Server that you must add to the specified roles. By default, the database names start with StarterSite. However, you might have specified different database names when you unpacked your site.
|
Database Account |
Database |
Roles |
|---|---|---|
|
CatalogWebSvc |
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 |
|
MarketingWebSvc |
MSCS_Admin |
admin_reader_role, admin_cache_poller_role |
|
|
StarterSite_Marketing |
mktg_MarketingService_role, mktg_promoCodeGenerator_role |
|
|
StarterSite_MarketingLists |
db_owner |
|
|
StarterSite_ProductCatalog |
ctlg_catalogReaderRole |
|
|
StarterSite_Profiles |
Profile_Reader, Profile_Schema_Reader, ctlg_catalogReaderRole |
|
OrdersWebSvc |
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 |
|
ProfilesWebSvc |
MSCS_Admin |
admin_reader_role, admin_cache_poller_role |
|
|
StarterSite_Profiles |
Profile_Schema_Manager, Profile_Runtime, ctlg_CatalogWriterRole |
|
RunTimeUser |
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 |
|
CSStageSvc |
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 |
|
<CS Staging User> |
MSCS_Admin |
db_datareader |
|
|
MSCS_CatalogScratch |
db_datareader, db_datawriter, db_ddladmin |
|
|
StarterSite_ProductCatalog |
ctlg_CatalogWriterRole, Inventory_ReaderRoles |