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 |