Database permissions
SQL Database Account, Database, and Database Role User Mapping
The following table lists the accounts that you must add 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 |
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 |