Partager via


How to Grant Permissions on the Runtime Site Databases

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, in SQL Server, 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