Add 2FA account into CAMIS

Connect using TWOFA@TTSXP18

Get next value from sequence: SELECT AC040_STAKEHOLDER_ID_SEQ.nextval FROM dual;

Create record in the TWOFA.AC040_STAKEHOLDER table - use an existing record as a template
**Note: the value in GLOBAL_USERID_LBL is just a random bunch of characters - 12 characters

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 ([Value from Step 2], 1, 'First Name', 'Last Name', 1, '[Random generated 12 char alphanumeric]', 1);

Example:

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 (2491, 1, 'Samia', 'Dawi', 1, 'J5MBODB0SAJM', 1);

Create record in the TWOFA.AC043_INTERNAL_STAKEHOLDER table - use existing record as a template

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

Create in the TWOFA.AC002_XREF_APPLICATION_USER table - use existing record as a template
** BE SURE TO SET ROLE_CD = 2