How to Grant Permissions on the Runtime Site Databases

This topic provides steps for granting 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