Switching a delegate's region in NDWL

Owned by Christopher Collins
Last updated: Jul 20, 2022 by Alain Asgill
1 min read

This is not a regular practice. Generally, the NDWL System Administrator would create a separate user account for the delegate by region.

To switch a region you need to modify the RGN_CD value in the following tables:

  • NAPA_WEB_USERS_RGN

  • USR

  • USER_ROLE

NOTE: Use the following steps to accomplish this using TOAD:

  • Modify the RGN_CD in the NAPA_WEB_USERS_RGN table to the new value.

  • Duplicate the row in the USR table for the delegate and then change the RGN_CD to the region requested.

  • Modify the RGN_CD to correspond to the requested region for the existing user role for the delegate in the USER_ROLE table.

  • For the last step, delete the original row from the USR table for the delegate original RGN_CD.