How to Grant Permissions on the Runtime Site Databases

For the latest version of Commerce Server 2007 Help, see the Microsoft Web site.

This topic provides steps for granting permissions on the runtime site databases.

On the runtime database server, use SQL Server 2000 Enterprise Manager or SQL Server 2005 Management Studio to grant the DTSImport account the following permissions:

Database	Permissions
MSCS_Admin	admin_reader_role
<sitename>_DataWarehouse	db_datareader
<sitename>_marketing	db_datareader
<sitename>_marketing_lists	db_datareader
<sitename>_productcatalog	db_datareader
<sitename>_profiles	db_datareader, Profile_Schema_Reader
<sitename>_transactionconfig	db_datareader
<sitename>_transactions	db_datareader

See Also