Share via


Dts_CommerceDB_Campaign_SecurityRole.sql Script

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

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

The Dts_CommerceDB_Campaign_SecurityRole.sql script grants the DTS_Import role Select permissions on the following Campaigns database tables:

ad_item
campaign
campaign_item
campaign_item_types
creative
creative_size
creative_type
creative_type_xref
customer
dm_item
event_type
industry_code
order_discount
page_group
page_group_xref
target
target_group
target_group_xref

See Also

Permissions Required to Run DTS Tasks

Copyright © 2005 Microsoft Corporation.
All rights reserved.