Share via


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.

To grant 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

Other Resources

Configuring the Data Warehouse and Analysis Server

Configuring the Business Management Server