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_datawriter
db_ddladmin
<SiteName>_productcatalog
ctlg_CatalogWriterRole
db_securityadmin
Inventory_ReaderRole
Inventory_WriterRole
ctlg_CatalogReaderRole
Inventory_RuntimeRole
<SiteName>_marketing
mktg_MarketingService_role
mktg_promoCodeGenerator_role
mktg_runtime_role
mktg_directmailer_role
mktg_staging_role
<SiteName>_marketing_lists
db_owner
<SiteName>_profiles
Profile_Schema_Manager
Profile_Runtime
<SiteName>_transactionconfig
Orders_Management
Orders_Runtime
<SiteName>_transactions