Dts_CommerceDB_Transaction_SecurityRole.sql Script

  • Article

Run this script against the Transaction database. For instructions, see Scripts for Securing Databases Accessed by DTS Tasks.

This script creates the DTS_ImportRole on the Transaction database. Add the user who is going to run the Transaction data import DTS task to this role.

The Dts_CommerceDB_Transaction_SecurityRole.sql script grants the DTS_Import role Select permissions on the following Transaction database tables:

OrderFormHeader
OrderFormLineItems
OrderGroup
OrderGroupAddresses
TransCategory
TransDimension

See Also

Permissions Required to Run DTS Tasks

Copyright © 2005 Microsoft Corporation.
All rights reserved.