Access required in SQL server while creating a new site in Commerce Server 2007 : For a single user
After creating a site in Commerce Server 2007, following roles need to be mapped to the user (under which context the commerce server web srevices are running).
|
Database Name |
Role |
|
MSCS_Admin |
db_datareader |
|
|
admin_reader_role |
|
MSCS_CatalogScratch |
db_datareader |
|
|
db_datawriter |
|
|
db_ddladmin |
|
<SiteName>_productcatalog |
ctlg_CatalogWriterRole |
|
|
db_datareader |
|
|
db_datawriter |
|
|
db_ddladmin |
|
|
db_securityadmin |
|
|
Inventory_ReaderRole |
|
|
Inventory_WriterRole |
|
|
ctlg_CatalogReaderRole |
|
|
Inventory_RuntimeRole |
|
<SiteName>_marketing |
mktg_MarketingService_role |
|
|
mktg_promoCodeGenerator_role |
|
|
db_ddladmin |
|
|
mktg_runtime_role |
|
|
mktg_directmailer_role |
|
|
mktg_staging_role |
|
<SiteName>_marketing_lists |
db_owner |
|
|
db_datareader |
|
<SiteName>_profiles |
Profile_Schema_Manager |
|
|
Profile_Runtime |
|
<SiteName>_transactionconfig |
Orders_Management |
|
|
Orders_Runtime |
|
<SiteName>_transactions |
Orders_Management |
|
|
Orders_Runtime |
