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 |