Share via

Dts_CommerceDB_UPM_SecurityRole.sql Script

  • Article

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

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

The Dts_CommerceDB_UPM_SecurityRole.sql script grants the DTS_Import role Select permissions on the following Profiles database tables:

ClassDef
ClsAttrib
ColDef
CommerceServerCatalogs
GroupMem
MemAttrib
MemberDef
RelDef
SourceAttrib
SourceDef
TableDef

Profile Schema Changes

If you change the profile schema and add new objects, you will need to grant Select permissions on those objects so the Profile data import task works correctly.

For example, if you unpack a Solution Site, you must grant Select permissions on the following tables for the profile schema included with the Solution Sites:

Addresses
BlanketPOs
OrganizationObject
UserObject

See Also

Permissions Required to Run DTS Tasks

Copyright © 2005 Microsoft Corporation.
All rights reserved.