Advertisement
mugs

user quickstart permissions sql

Feb 26th, 2015
267
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.50 KB | None | 0 0
  1. INSERT INTO KRIM_ROLE_MBR_T (ROLE_MBR_ID,ROLE_ID,MBR_ID,MBR_TYP_CD,LAST_UPDT_DT,OBJ_ID,VER_NBR)
  2. VALUES
  3. (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);
  4.  
  5. INSERT INTO `krim_role_mbr_attr_data_t`
  6. (`ATTR_DATA_ID`,`OBJ_ID`,`VER_NBR`,`ROLE_MBR_ID`,`KIM_TYP_ID`,`KIM_ATTR_DEFN_ID`,`ATTR_VAL`)
  7. VALUES (250220151752,uuid(),1, 250220151636,'68','47','000001');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement