text: DELIMITER /
  INSERT INTO KRIM_PERM_ID_BS_S VALUES(NULL)
  /
  INSERT INTO KRIM_PERM_T (PERM_ID, OBJ_ID, VER_NBR, PERM_TMPL_ID, NMSPC_CD, NM, DESC_TXT, ACTV_IND)
  VALUES ((SELECT (MAX(ID)) FROM KRIM_PERM_ID_BS_S), UUID(), 1, 10, 'KC-SYS', 'Maintain Training', 'Permission for managing the training maintenance document', 'Y')
  /
  INSERT INTO KRIM_PERM_ID_BS_S VALUES(NULL)
  /
  INSERT INTO KRIM_PERM_T (PERM_ID, OBJ_ID, VER_NBR, PERM_TMPL_ID, NMSPC_CD, NM, DESC_TXT, ACTV_IND)
  VALUES ((SELECT (MAX(ID)) FROM KRIM_PERM_ID_BS_S), UUID(), 1, 10, 'KC-SYS', 'Maintain Person Training', 'Permission for managing the person training maintenance document', 'Y')
  /
  INSERT INTO KRIM_ROLE_ID_BS_S VALUES(NULL)
  /
  INSERT INTO KRIM_ROLE_T (ROLE_ID, OBJ_ID, VER_NBR, ROLE_NM, NMSPC_CD, DESC_TXT, KIM_TYP_ID, ACTV_IND, LAST_UPDT_DT)
  VALUES ((SELECT (MAX(ID)) FROM KRIM_ROLE_ID_BS_S), UUID(), 1, 'Modify Training', 'KC-SYS', 'Role for maintaining training and person training', (SELECT KIM_TYP_ID FROM KRIM_TYP_T WHERE NM = 'View Edit Mode'), 'Y', NOW())
  /
  INSERT INTO KRIM_ROLE_PERM_ID_BS_S VALUES(NULL)
  /
  INSERT INTO KRIM_ROLE_PERM_T (ROLE_PERM_ID, OBJ_ID, VER_NBR, ROLE_ID, PERM_ID, ACTV_IND)
  VALUES ((SELECT (MAX(ID)) FROM KRIM_ROLE_PERM_ID_BS_S), UUID(), 1, (SELECT ROLE_ID FROM KRIM_ROLE_T WHERE ROLE_NM = 'Modify Training' AND NMSPC_CD = 'KC-SYS'), (SELECT PERM_ID FROM KRIM_PERM_T WHERE NM = 'Maintain Training' AND NMSPC_CD = 'KC-SYS'), 'Y')
  /
  INSERT INTO KRIM_ROLE_PERM_ID_BS_S VALUES(NULL)
  /
  INSERT INTO KRIM_ROLE_PERM_T (ROLE_PERM_ID, OBJ_ID, VER_NBR, ROLE_ID, PERM_ID, ACTV_IND)
  VALUES ((SELECT (MAX(ID)) FROM KRIM_ROLE_PERM_ID_BS_S), UUID(), 1, (SELECT ROLE_ID FROM KRIM_ROLE_T WHERE ROLE_NM = 'Modify Training' AND NMSPC_CD = 'KC-SYS'), (SELECT PERM_ID FROM KRIM_PERM_T WHERE NM = 'Maintain Person Training' AND NMSPC_CD = 'KC-SYS'), 'Y')
  /
  
  DELIMITER ;
  