Page Comparison

...

The following sections explain:

1. Adding a 2FA admin account to an existing CAMIS Profile.

2. Checking what 2FA Admin profiles exist already.

3. Troubleshooting your existing CAMIS profile.

To add 2FA Admin to an existing profile.

...

1. Get next value from sequence: SELECT AC040_STAKEHOLDER_ID_SEQ.nextval FROM dual;
   **This will be used as the STAKEHOLDER_ID

2. Create a record in the TWOFA.AC040_STAKEHOLDER table
   **Note: GLOBAL_USERID_LBL is just a random string of 12 alphanumeric characters. You can use sites like https://privacycanada.net/strong-password-generator/ to generate the string

   Code Block
   language sql
   INSERT INTO TWOFA.AC040_STAKEHOLDER (STAKEHOLDER_ID, STAKEHOLDER_TYPE_CD, NAME_FIRST_NM, NAME_LAST_NM, STAKEHOLDER_CREATED_ID, GLOBAL_USERID_LBL, USER_LAST_UPDATE_ID) VALUES (:stakeholder_id, 1, 'First Name', 'Last Name', 1, :12_chars_alphanumeric, 1);

3. Create a record in TWOFA.AC043_INTERNAL_STAKEHOLDER

   Code Block
   language sql
   INSERT INTO TWOFA.AC043_INTERNAL_STAKEHOLDER VALUES (:stakeholder_id, 1, :12_chars_alphanumeric, 1, :tc_user_id, SYSDATE, NULL, SYSDATE, 1);

4. Connect using CAMIS_DATA_ADMIN@CAMISP

5. Copy the string from TWOFA.AC040_STAKEHOLDER.GLOBAL_USERID_LBL into the CAMIS database CAMIS.AA008_APPLICATION_USER.TWOFA_USERID_LBL for the newly created TWOFA account

   Code Block
   language sql
   UPDATE CAMIS.AA008_APPLICATION_USER SET TWOFA_USERID_LBL = :12_chars_alphanumeric WHERE TC_USER_ID = :tc_user_id;

6. Create a record in TWOFA.AC002_XREF_APPLICATION_USER with the following standard values

   Code Block
   language sql
   INSERT INTO TWOFA.AC002_XREF_APPLICATION_USER (STAKEHOLDER_ID, APPLICATION_CD, ROLE_CD, STAKEHOLDER_CREATED_ID, USER_LAST_UPDATE_ID) VALUES (:stakeholder_id, 4, 2, 1, 1);

Example:
User: Michelle Le (LEMI)

...