How to Create a User Account in PID, SVCP, TCMDG and Claims

Owned by Tibo (Unlicensed)
Last updated: Mar 24, 2021 by Barry O'Neill (Unlicensed)
4 min read

The below screenshots show the process for creating admin accounts since I had to create one anyway for Will. To create a regular account for an end-user, simply select the appropriate user role and do not select Admin.

 

  1. Navigate to Claims Administration url found in this table.

    Note: only users with one of the following roles will be able to view this page:

     

  2. Click New User.

     

  3. Select Admin role in PID, TCMDG and claim_management. You will not be able to do the same for SVCP yet. Scroll to the bottom and click Save.

     

  4. To have admin rights in SVCP, create a user account in the SVCP application. Find the URL from this linked table.

  5. Create the SVCP account using these instructions.\

  6. In Claims, find the account you just created in SVCP and click on it to view its details.

     

     

  7. Click Edit.

     

  8. Operator will already be pre-selected. Add Admin role then scroll down and click Save.

     

     

  9. You are done.

 

How to Create a User Account in PID, SVCP, TCMDG and Claims using SQL (instead of the above)

--USING: MSCAIID.WORLD / MSCAIIA.WORLD / MSCAIIP.WORLD --GET: The persons windows ID. That is what is used for the USER_NAME_NM --TO DETERMINE WHICH STAKEHOLDER_ID TO START WITH IN THE BELOW INSERTS (MAX + 1 = STARTING NUMBER TO USE) --select DATE_CREATED_DTE, STAKEHOLDER_ID from AC040_STAKEHOLDER order by DATE_CREATED_DTE desc; --INSERTING into AC040_STAKEHOLDER (this uses "1" as USER_LAST_UPDATE_ID as that value would always exist) SET DEFINE OFF; --Insert into AC040_STAKEHOLDER (STAKEHOLDER_ID,USER_NAME_NM,NAME_LAST_NM,NAME_FIRST_NM,ACTIVE_IND,DATE_LAST_ACTIVITY_DTE,DATE_CREATED_DTE,DATE_LAST_UPDATE_DTE,DATE_DELETED_DTE,USER_LAST_UPDATE_ID,EXTERNAL_STAKEHOLDER_ID,EXTERNAL_USER_IND) values (27331,'ONEILBA','ONEILL','BARRY',1,to_date('18-JAN-21','DD-MON-RR'),to_date('18-JAN-21','DD-MON-RR'),to_date('18-JAN-21','DD-MON-RR'),null,1,null,0); --USE THIS TO DETERMINE WHICH STAKEHOLDER_ROLE_ID TO START WITH IN THE BELOW INSERTS (MAX + 1 = STARTING NUMBER TO USE) select MAX(STAKEHOLDER_ROLE_ID) from DM005_STAKEHOLDER_ROLE; --THE USER_LAST_UPDATE_ID VALUE BELOW IS BASED ON AN EXISTING ADMIN ACCOUNT IN THE DATABASES. --(ID = 1 is the first account in DEV/ACC/PROD and is the default admin account/role as well) --INSERTING into DM005_STAKEHOLDER_ROLE (this adds permissions at all levels for PID, SVCP, TCMDG, anmd Claims) SET DEFINE OFF; Insert into DM005_STAKEHOLDER_ROLE (STAKEHOLDER_ROLE_ID,ROLE_ID,STAKEHOLDER_ID,DATE_VALID_FROM_DTE,DATE_VALID_TO_DTE,DATE_CREATED_DTE,DATE_LAST_UPDATE_DTE,DATE_DELETED_DTE,USER_LAST_UPDATE_ID) values (30129,1,27331,null,null,to_date('15-JAN-21','DD-MON-RR'),to_date('15-JAN-21','DD-MON-RR'),null,1); Insert into DM005_STAKEHOLDER_ROLE (STAKEHOLDER_ROLE_ID,ROLE_ID,STAKEHOLDER_ID,DATE_VALID_FROM_DTE,DATE_VALID_TO_DTE,DATE_CREATED_DTE,DATE_LAST_UPDATE_DTE,DATE_DELETED_DTE,USER_LAST_UPDATE_ID) values (30130,2,27331,null,null,to_date('15-JAN-21','DD-MON-RR'),to_date('15-JAN-21','DD-MON-RR'),null,1); Insert into DM005_STAKEHOLDER_ROLE (STAKEHOLDER_ROLE_ID,ROLE_ID,STAKEHOLDER_ID,DATE_VALID_FROM_DTE,DATE_VALID_TO_DTE,DATE_CREATED_DTE,DATE_LAST_UPDATE_DTE,DATE_DELETED_DTE,USER_LAST_UPDATE_ID) values (30131,4,27331,null,null,to_date('15-JAN-21','DD-MON-RR'),to_date('15-JAN-21','DD-MON-RR'),null,1); Insert into DM005_STAKEHOLDER_ROLE (STAKEHOLDER_ROLE_ID,ROLE_ID,STAKEHOLDER_ID,DATE_VALID_FROM_DTE,DATE_VALID_TO_DTE,DATE_CREATED_DTE,DATE_LAST_UPDATE_DTE,DATE_DELETED_DTE,USER_LAST_UPDATE_ID) values (30132,5,27331,null,null,to_date('15-JAN-21','DD-MON-RR'),to_date('15-JAN-21','DD-MON-RR'),null,1); Insert into DM005_STAKEHOLDER_ROLE (STAKEHOLDER_ROLE_ID,ROLE_ID,STAKEHOLDER_ID,DATE_VALID_FROM_DTE,DATE_VALID_TO_DTE,DATE_CREATED_DTE,DATE_LAST_UPDATE_DTE,DATE_DELETED_DTE,USER_LAST_UPDATE_ID) values (30133,3,27331,null,null,to_date('15-JAN-21','DD-MON-RR'),to_date('15-JAN-21','DD-MON-RR'),null,1); Insert into DM005_STAKEHOLDER_ROLE (STAKEHOLDER_ROLE_ID,ROLE_ID,STAKEHOLDER_ID,DATE_VALID_FROM_DTE,DATE_VALID_TO_DTE,DATE_CREATED_DTE,DATE_LAST_UPDATE_DTE,DATE_DELETED_DTE,USER_LAST_UPDATE_ID) values (30134,16,27331,null,null,to_date('15-JAN-21','DD-MON-RR'),to_date('15-JAN-21','DD-MON-RR'),null,1); Insert into DM005_STAKEHOLDER_ROLE (STAKEHOLDER_ROLE_ID,ROLE_ID,STAKEHOLDER_ID,DATE_VALID_FROM_DTE,DATE_VALID_TO_DTE,DATE_CREATED_DTE,DATE_LAST_UPDATE_DTE,DATE_DELETED_DTE,USER_LAST_UPDATE_ID) values (30135,18,27331,null,null,to_date('15-JAN-21','DD-MON-RR'),to_date('15-JAN-21','DD-MON-RR'),null,1); Insert into DM005_STAKEHOLDER_ROLE (STAKEHOLDER_ROLE_ID,ROLE_ID,STAKEHOLDER_ID,DATE_VALID_FROM_DTE,DATE_VALID_TO_DTE,DATE_CREATED_DTE,DATE_LAST_UPDATE_DTE,DATE_DELETED_DTE,USER_LAST_UPDATE_ID) values (30136,17,27331,null,null,to_date('15-JAN-21','DD-MON-RR'),to_date('15-JAN-21','DD-MON-RR'),null,1); Insert into DM005_STAKEHOLDER_ROLE (STAKEHOLDER_ROLE_ID,ROLE_ID,STAKEHOLDER_ID,DATE_VALID_FROM_DTE,DATE_VALID_TO_DTE,DATE_CREATED_DTE,DATE_LAST_UPDATE_DTE,DATE_DELETED_DTE,USER_LAST_UPDATE_ID) values (30137,6,27331,null,null,to_date('15-JAN-21','DD-MON-RR'),to_date('15-JAN-21','DD-MON-RR'),null,1); Insert into DM005_STAKEHOLDER_ROLE (STAKEHOLDER_ROLE_ID,ROLE_ID,STAKEHOLDER_ID,DATE_VALID_FROM_DTE,DATE_VALID_TO_DTE,DATE_CREATED_DTE,DATE_LAST_UPDATE_DTE,DATE_DELETED_DTE,USER_LAST_UPDATE_ID) values (30138,7,27331,null,null,to_date('15-JAN-21','DD-MON-RR'),to_date('15-JAN-21','DD-MON-RR'),null,1); Insert into DM005_STAKEHOLDER_ROLE (STAKEHOLDER_ROLE_ID,ROLE_ID,STAKEHOLDER_ID,DATE_VALID_FROM_DTE,DATE_VALID_TO_DTE,DATE_CREATED_DTE,DATE_LAST_UPDATE_DTE,DATE_DELETED_DTE,USER_LAST_UPDATE_ID) values (30139,8,27331,null,null,to_date('15-JAN-21','DD-MON-RR'),to_date('15-JAN-21','DD-MON-RR'),null,1); Insert into DM005_STAKEHOLDER_ROLE (STAKEHOLDER_ROLE_ID,ROLE_ID,STAKEHOLDER_ID,DATE_VALID_FROM_DTE,DATE_VALID_TO_DTE,DATE_CREATED_DTE,DATE_LAST_UPDATE_DTE,DATE_DELETED_DTE,USER_LAST_UPDATE_ID) values (30140,9,27331,null,null,to_date('15-JAN-21','DD-MON-RR'),to_date('15-JAN-21','DD-MON-RR'),null,1); Insert into DM005_STAKEHOLDER_ROLE (STAKEHOLDER_ROLE_ID,ROLE_ID,STAKEHOLDER_ID,DATE_VALID_FROM_DTE,DATE_VALID_TO_DTE,DATE_CREATED_DTE,DATE_LAST_UPDATE_DTE,DATE_DELETED_DTE,USER_LAST_UPDATE_ID) values (30141,15,27331,null,null,to_date('15-JAN-21','DD-MON-RR'),to_date('15-JAN-21','DD-MON-RR'),null,1); Insert into DM005_STAKEHOLDER_ROLE (STAKEHOLDER_ROLE_ID,ROLE_ID,STAKEHOLDER_ID,DATE_VALID_FROM_DTE,DATE_VALID_TO_DTE,DATE_CREATED_DTE,DATE_LAST_UPDATE_DTE,DATE_DELETED_DTE,USER_LAST_UPDATE_ID) values (30142,11,27331,null,null,to_date('15-JAN-21','DD-MON-RR'),to_date('15-JAN-21','DD-MON-RR'),null,1); Insert into DM005_STAKEHOLDER_ROLE (STAKEHOLDER_ROLE_ID,ROLE_ID,STAKEHOLDER_ID,DATE_VALID_FROM_DTE,DATE_VALID_TO_DTE,DATE_CREATED_DTE,DATE_LAST_UPDATE_DTE,DATE_DELETED_DTE,USER_LAST_UPDATE_ID) values (30143,12,27331,null,null,to_date('15-JAN-21','DD-MON-RR'),to_date('15-JAN-21','DD-MON-RR'),null,1); Insert into DM005_STAKEHOLDER_ROLE (STAKEHOLDER_ROLE_ID,ROLE_ID,STAKEHOLDER_ID,DATE_VALID_FROM_DTE,DATE_VALID_TO_DTE,DATE_CREATED_DTE,DATE_LAST_UPDATE_DTE,DATE_DELETED_DTE,USER_LAST_UPDATE_ID) values (30144,13,27331,null,null,to_date('15-JAN-21','DD-MON-RR'),to_date('15-JAN-21','DD-MON-RR'),null,1); Insert into DM005_STAKEHOLDER_ROLE (STAKEHOLDER_ROLE_ID,ROLE_ID,STAKEHOLDER_ID,DATE_VALID_FROM_DTE,DATE_VALID_TO_DTE,DATE_CREATED_DTE,DATE_LAST_UPDATE_DTE,DATE_DELETED_DTE,USER_LAST_UPDATE_ID) values (30145,14,27331,null,null,to_date('15-JAN-21','DD-MON-RR'),to_date('15-JAN-21','DD-MON-RR'),null,1); Insert into DM005_STAKEHOLDER_ROLE (STAKEHOLDER_ROLE_ID,ROLE_ID,STAKEHOLDER_ID,DATE_VALID_FROM_DTE,DATE_VALID_TO_DTE,DATE_CREATED_DTE,DATE_LAST_UPDATE_DTE,DATE_DELETED_DTE,USER_LAST_UPDATE_ID) values (30146,10,27331,null,null,to_date('15-JAN-21','DD-MON-RR'),to_date('15-JAN-21','DD-MON-RR'),null,1); Insert into DM005_STAKEHOLDER_ROLE (STAKEHOLDER_ROLE_ID,ROLE_ID,STAKEHOLDER_ID,DATE_VALID_FROM_DTE,DATE_VALID_TO_DTE,DATE_CREATED_DTE,DATE_LAST_UPDATE_DTE,DATE_DELETED_DTE,USER_LAST_UPDATE_ID) values (30147,41,27331,null,null,to_date('15-JAN-21','DD-MON-RR'),to_date('15-JAN-21','DD-MON-RR'),null,1); Insert into DM005_STAKEHOLDER_ROLE (STAKEHOLDER_ROLE_ID,ROLE_ID,STAKEHOLDER_ID,DATE_VALID_FROM_DTE,DATE_VALID_TO_DTE,DATE_CREATED_DTE,DATE_LAST_UPDATE_DTE,DATE_DELETED_DTE,USER_LAST_UPDATE_ID) values (30148,42,27331,null,null,to_date('15-JAN-21','DD-MON-RR'),to_date('15-JAN-21','DD-MON-RR'),null,1); Insert into DM005_STAKEHOLDER_ROLE (STAKEHOLDER_ROLE_ID,ROLE_ID,STAKEHOLDER_ID,DATE_VALID_FROM_DTE,DATE_VALID_TO_DTE,DATE_CREATED_DTE,DATE_LAST_UPDATE_DTE,DATE_DELETED_DTE,USER_LAST_UPDATE_ID) values (30149,43,27331,null,null,to_date('15-JAN-21','DD-MON-RR'),to_date('15-JAN-21','DD-MON-RR'),null,1); Insert into DM005_STAKEHOLDER_ROLE (STAKEHOLDER_ROLE_ID,ROLE_ID,STAKEHOLDER_ID,DATE_VALID_FROM_DTE,DATE_VALID_TO_DTE,DATE_CREATED_DTE,DATE_LAST_UPDATE_DTE,DATE_DELETED_DTE,USER_LAST_UPDATE_ID) values (30150,44,27331,null,null,to_date('15-JAN-21','DD-MON-RR'),to_date('15-JAN-21','DD-MON-RR'),null,1);

 

How to Check User Roles in Apps that use Claims (Claims, PID, TCMDG, SVCP)

--USING: MSCAIID.WORLD / MSCAIIA.WORLD / MSCAIIP.WORLD --USING Users StakeholderID (User ID) and for all app that use claims: select s.stakeholder_id, s.user_name_nm, a.application_id, a.application_name_nm, r.role_id, r.role_name_nm from ac040_stakeholder s, dm001_application a, dm002_role r where a.application_id = r.application_id and s.stakeholder_id = 27331; --USING Users First Name, and for all app that use claims: select s.stakeholder_id, s.user_name_nm, a.application_id, a.application_name_nm, r.role_id, r.role_name_nm from ac040_stakeholder s, dm001_application a, dm002_role r where a.application_id = r.application_id and s.name_first_nm LIKE 'Dom'; --USING Users Email (user name) and for all app that use claims: select s.stakeholder_id, s.user_name_nm, a.application_id, a.application_name_nm, r.role_id, r.role_name_nm from ac040_stakeholder s, dm001_application a, dm002_role r where a.application_id = r.application_id and s.user_name_nm LIKE 'DOMENIC.BUETI@TC.GC.CA'; --email --USING: unsername and for SVCP only: select s.stakeholder_id, s.user_name_nm, a.application_id, a.application_name_nm, r.role_id, r.role_name_nm from ac040_stakeholder s, dm001_application a, dm002_role r where a.application_id = r.application_id and s.user_name_nm LIKE 'DOMENIC.BUETI@TC.GC.CA' and a.application_name_nm = 'SVCP'; --Possible application_name_nm: claim_management, PID, TCMDG, SVCP