text: 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)
  SELECT MAX(ID), UUID(), 1, (SELECT ROLE_ID FROM KRIM_ROLE_T WHERE NMSPC_CD = 'KC-UNT' AND ROLE_NM = 'IRB Administrator'), 
      (SELECT PERM_ID FROM KRIM_PERM_T WHERE NMSPC_CD = 'KC-PROTOCOL' AND NM = 'Maintain Protocol Notes'), 'Y' FROM KRIM_ROLE_PERM_ID_BS_S;
  
  INSERT INTO KRIM_ROLE_PERM_ID_BS_S VALUES (NULL);
  INSERT INTO KRIM_ROLE_PERM_T (ACTV_IND,OBJ_ID,PERM_ID,ROLE_ID,ROLE_PERM_ID,VER_NBR)
  SELECT 'Y',UUID(),
      (SELECT PERM_ID FROM KRIM_PERM_T WHERE NMSPC_CD = 'KC-AWARD' AND NM = 'Create Award Account'),
      (SELECT ROLE_ID FROM KRIM_ROLE_T WHERE NMSPC_CD = 'KC-ADM' AND ROLE_NM = 'OSP Administrator'),
      MAX(ID),1 FROM KRIM_ROLE_PERM_ID_BS_S;
  
  INSERT INTO KRIM_ROLE_PERM_ID_BS_S VALUES (NULL);
  INSERT INTO KRIM_ROLE_PERM_T (ACTV_IND,OBJ_ID,PERM_ID,ROLE_ID,ROLE_PERM_ID,VER_NBR)
  SELECT 'Y',UUID(),
      (SELECT PERM_ID FROM KRIM_PERM_T WHERE NMSPC_CD = 'KC-AB' AND NM = 'Modify AwardBudget'),
      (SELECT ROLE_ID FROM KRIM_ROLE_T WHERE NMSPC_CD = 'KC-AB' AND ROLE_NM = 'Award Budget Aggregator'),
      MAX(ID),1 FROM KRIM_ROLE_PERM_ID_BS_S;
  
  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) 
  SELECT MAX(ID), UUID(), 0, 
      (SELECT ROLE_ID FROM KRIM_ROLE_T WHERE NMSPC_CD = 'KR-SYS' AND ROLE_NM = 'Technical Administrator'), 
      (SELECT PERM_ID FROM KRIM_PERM_T WHERE NMSPC_CD = 'KC-PD' AND NM = 'Maintain Questionnaire Usage'), 'Y' 
      FROM KRIM_ROLE_PERM_ID_BS_S;
  
  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) 
  SELECT MAX(ID), UUID(), 0, 
      (SELECT ROLE_ID FROM KRIM_ROLE_T WHERE NMSPC_CD = 'KR-SYS' AND ROLE_NM = 'Technical Administrator'), 
      (SELECT PERM_ID FROM KRIM_PERM_T WHERE NMSPC_CD = 'KC-PROTOCOL' AND NM = 'Maintain Questionnaire Usage'), 'Y' 
      FROM KRIM_ROLE_PERM_ID_BS_S;
  
  COMMIT;
  