IBM SG24-6320-00 manual Role changes, Our example this command retrieved 6 records

6320ch_before_migration.fm Draft Document for Review July 28, 2004 7:33 pm

where registertype in ('A','S')

and users_id in (select users_id from accmbrgrp)

Role changes

Some of the roles in WebSphere Commerce Suite V5.1 are no longer available in WebSphere Commerce V5.6. Table 10-5lists the WebSphere Commerce Suite V5.1 and the roles that should be used in WebSphere Commerce V5.6.

Table 10-5 Roles that are not included in WebSphere Commerce V5.6

WebSphere Commerce Suite V5.1	WebSphere Commerce V5.6 role
role
Order clerk (-5)	Customer Service Supervisor (-14)
Store Developer (-7)	Site Administrator (-1)
Customer role	Refer to WebSphere Commerce V5.6
	migration guide for more information
Merchant	Seller
Merchandising Manager	Product Manager

Refer to Migration Guide for Windows 2000 and Windows 2003 - migrating from WebSphere Commerce Suite V5.1 for more information on the details regarding role migration.

The recommended approach to the roles, that are not included in WebSphere Commerce V5.6, is to replace them with roles which have the same function.

If a role is found by the migration script, and not found in WebSphere Commerce V5.6, it is migrated as a user-defined role.

Our application had two users with the following roles which needed to be changed:

1.Order Clerk

2.Merchandising Manager

3.Customer Service Representative

We found that Store Administrator would be a more suitable role for these two users. Therefore we assigned these two users the Store Administrator role instead.

1.Identify the users that should be assigned the Store Administrator role.

DB2 select * from accmbrgrp

In our example this command retrieved 6 records.

198Keeping Commerce Applications Updated WebSphere Commerce 5.1 to 5.6 Migration Guide