Dts_CommerceDB_Catalog_SecurityRole.sql Script

  • Article

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

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

The Dts_CommerceDB_Catalog_SecurityRole.sql script grants the DTS_Import role Select permissions on the following Catalog database tables:

  • CatalogGlobal
  • CatalogAttributes
  • All the tables and views that have a prefix of the catalog name from the CatalogGlobal table

See Also

Permissions Required to Run DTS Tasks

Copyright © 2005 Microsoft Corporation.
All rights reserved.