How to Create a NORMS User on Production for support purposes

Step 1: Open NORMS Production (https://eig.tc.gc.ca/norms/) and 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>;