Dts_AdminDB_SecurityRole.sql Script
Run this script against the Administration database. For instructions, see Scripts for Securing Databases Accessed by DTS Tasks.
This script creates the DTS_ImportRole on the Administration database. Add the user who is going to run the Commerce Server DTS tasks to this role.
The Dts_AdminDB_SecurityRole.sql script grants the DTS_Import role permissions on the following Administration database tables.
| Administration table | Permissions required by the DTS tasks |
|---|---|
| ExtendedProps | Select Insert Update Delete |
| Pupdbscripts | Select |
| ResourceProps | Select Insert Update Delete |
| Resources | Select Update |
| SiteResources | Select |
| Sites | Select Update |
| SystemProps | Select |
See Also
Permissions Required to Run DTS Tasks
Copyright © 2005 Microsoft Corporation.
All rights reserved.