How to Create a NORMS User on Production for support purposes

In Development

Step 1: Open NORMS Development, then go to the User page

Step 2: Press the “Add” button at the top of the list

Step 3: Lookup the user by name (first or last) and select the user

Step 4: Set the Region to NCR and Branch to AARB

Existing users that are based outside of NCR will initially only see the region and Branch available to their region (example ONT).
The accounts for Siamak and Dean were already set to NCR, AARB.
When adding Sam, her region and branch defaulted to ONT and the AARB branch was not available.
I updated her account to NCR and the AARB branch using a script similar to the one below:

update AC041_INTERNAL_STAKEHOLDER 
set TC_REGION_CD = 4, TC_DIRECTORATE_CD = 'AARB' 
where STAKEHOLDER_ID=<stakeholder_id>;