Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- INSERT INTO KRIM_ROLE_MBR_T (ROLE_MBR_ID,ROLE_ID,MBR_ID,MBR_TYP_CD,LAST_UPDT_DT,OBJ_ID,VER_NBR)
- VALUES
- (250220151636,(SELECT ROLE_ID FROM KRIM_ROLE_T WHERE NMSPC_CD = 'KC-UNT' AND ROLE_NM = 'Proposal Creator'),(SELECT PRNCPL_ID FROM KRIM_PRNCPL_T WHERE PRNCPL_NM = 'quickstart'),'P',now(),uUID(),1);
- INSERT INTO `krim_role_mbr_attr_data_t`
- (`ATTR_DATA_ID`,`OBJ_ID`,`VER_NBR`,`ROLE_MBR_ID`,`KIM_TYP_ID`,`KIM_ATTR_DEFN_ID`,`ATTR_VAL`)
- VALUES (250220151752,uuid(),1, 250220151636,'68','47','000001');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement