 INSERT INTO KR_KIM_ENTITY_T(ENTITY_ID, OBJ_ID, ACTV_IND) 
     VALUES('e4', 'e4', 'Y')
 /
+
+INSERT INTO KR_KIM_ENTITY_T(ENTITY_ID, OBJ_ID, ACTV_IND) 
+    VALUES('e5', 'e5', 'N')
+/
+
+INSERT INTO KR_KIM_ENTITY_T(ENTITY_ID, OBJ_ID, ACTV_IND) 
+    VALUES('e6', 'e6', 'N')
+/
 commit
 /
 
+INSERT INTO KR_KIM_ENT_TYPE_T(ENT_TYP_CD, OBJ_ID, ENT_TYP_NM, DISPLAY_SORT_CD, ACTV_IND) 
+    VALUES('PERSON', 'et1', 'Person', 01, 'Y')
+/
+COMMIT
+/
 
 INSERT INTO KR_KIM_ENTITY_ENT_TYPE_T(ENTITY_ENT_TYPE_ID, OBJ_ID, ENT_TYP_CD, ENTITY_ID, ACTV_IND) 
     VALUES('et1', 'et1', 'PERSON', 'e1', 'Y')



INSERT INTO KR_KIM_ROLE_T(ROLE_ID, OBJ_ID, ROLE_NM, NMSPC_CD, ROLE_DESC, TYP_ID, ACTV_IND) 
    VALUES('r1', 'r1', 'poweruserrole', 'TEST', 'high level role that implies other roles', NULL, 'Y')
/
INSERT INTO KR_KIM_ROLE_T(ROLE_ID, OBJ_ID, ROLE_NM, NMSPC_CD, ROLE_DESC, TYP_ID, ACTV_IND) 
    VALUES('r2', 'r2', 'generalrole', 'TEST', 'role granted to large number of users', NULL, 'Y')
/

INSERT INTO KR_KIM_ROLE_REL_T(ROLE_REL_ID, OBJ_ID, ROLE_ID, CONTAINED_ROLE_ID) 

    VALUES('p3', 'p3', 'user3', 'e3', 'Y')
/
INSERT INTO KR_KIM_PRINCIPAL_T(PRNCPL_ID, OBJ_ID, PRNCPL_NM, ENTITY_ID, ACTV_IND) 
    VALUES('p41', 'p41', 'user41', 'e4', 'Y')
/
INSERT INTO KR_KIM_PRINCIPAL_T(PRNCPL_ID, OBJ_ID, PRNCPL_NM, ENTITY_ID, ACTV_IND) 
    VALUES('p42', 'p42', 'user42', 'e4', 'Y')
/
INSERT INTO KR_KIM_PRINCIPAL_T(PRNCPL_ID, OBJ_ID, PRNCPL_NM, ENTITY_ID, ACTV_IND) 
    VALUES('p4', 'p4', 'user4', 'e4', 'Y')
/
INSERT INTO KR_KIM_PRINCIPAL_T(PRNCPL_ID, OBJ_ID, PRNCPL_NM, ENTITY_ID, ACTV_IND) 
    VALUES('p5', 'p5', 'user5', 'e5', 'Y')
/
INSERT INTO KR_KIM_PRINCIPAL_T(PRNCPL_ID, OBJ_ID, PRNCPL_NM, ENTITY_ID, ACTV_IND) 
    VALUES('p6', 'p6', 'user6', 'e6', 'Y')
/
COMMIT
/

INSERT INTO KR_KIM_TYPE_T(KIM_TYPE_ID, OBJ_ID, TYPE_NM, SRVC_NM,  ACTV_IND) 
    VALUES('roleType1', 'roleType1', 'kim type for r1', 'kimRoleTypeService',  'Y')
/
INSERT INTO KR_KIM_TYPE_T(KIM_TYPE_ID, OBJ_ID, TYPE_NM, SRVC_NM,  ACTV_IND) 
    VALUES('roleType2', 'roleType2', 'kim type for r2', 'kimRoleTypeService',  'Y')
/
INSERT INTO KR_KIM_TYPE_T(KIM_TYPE_ID, OBJ_ID, TYPE_NM, SRVC_NM,  ACTV_IND) 
    VALUES('permType1', 'permType1', 'kim type for permTmpl1', 'permTypeService',  'Y')
/
INSERT INTO KR_KIM_TYPE_T(KIM_TYPE_ID, OBJ_ID, TYPE_NM, SRVC_NM,  ACTV_IND) 
    VALUES('permType2', 'permType2', 'kim type for permTmpl2', 'permTypeService',  'Y')
/
INSERT INTO KR_KIM_TYPE_T(KIM_TYPE_ID, OBJ_ID, TYPE_NM, SRVC_NM,  ACTV_IND) 
    VALUES('permType3', 'permType3', 'kim type for permTmpl3', 'permTypeService',  'Y')
/
INSERT INTO KR_KIM_TYPE_T(KIM_TYPE_ID, OBJ_ID, TYPE_NM, SRVC_NM,  ACTV_IND) 
    VALUES('rspType1', 'rspType1', 'kim type for tspTmpl1', 'responsibilityTypeService',  'Y')
/
INSERT INTO KR_KIM_TYPE_T(KIM_TYPE_ID, OBJ_ID, TYPE_NM, SRVC_NM,  ACTV_IND) 
    VALUES('rspType2', 'rspType2', 'kim type for tspTmpl2', 'responsibilityTypeService',  'Y')
/
INSERT INTO KR_KIM_TYPE_T(KIM_TYPE_ID, OBJ_ID, TYPE_NM, SRVC_NM,  ACTV_IND) 
    VALUES('groupType1', 'groupType1', 'kim type for Group 1', 'groupTypeService',  'Y')
/
INSERT INTO KR_KIM_TYPE_T(KIM_TYPE_ID, OBJ_ID, TYPE_NM, SRVC_NM,  ACTV_IND) 
    VALUES('groupType2', 'groupType2', 'kim type for Group 2', 'groupTypeService',  'Y')
/
COMMIT 
/

INSERT INTO KR_KIM_ATTRIBUTE_T(KIM_ATTRIB_ID, OBJ_ID, ATTRIB_NM, SRVC_NM,  ACTV_IND) 
    VALUES('kimAttr1', 'kimAttr1', 'Attribute 1', 'kimRoleTypeService',  'Y')
/
INSERT INTO KR_KIM_ATTRIBUTE_T(KIM_ATTRIB_ID, OBJ_ID, ATTRIB_NM, SRVC_NM,  ACTV_IND) 
    VALUES('kimAttr2', 'kimAttr2', 'Attribute 2', 'kimRoleTypeService',  'Y')
/
INSERT INTO KR_KIM_ATTRIBUTE_T(KIM_ATTRIB_ID, OBJ_ID, ATTRIB_NM, SRVC_NM,  ACTV_IND) 
    VALUES('kimAttr3', 'kimAttr3', 'Attribute 3', 'kimRoleTypeService',  'Y')
/
INSERT INTO KR_KIM_ATTRIBUTE_T(KIM_ATTRIB_ID, OBJ_ID, ATTRIB_NM, SRVC_NM,  ACTV_IND) 
    VALUES('kimAttr4', 'kimAttr4', 'Attribute 4', 'groupTypeService',  'Y')
/
INSERT INTO KR_KIM_ATTRIBUTE_T(KIM_ATTRIB_ID, OBJ_ID, ATTRIB_NM, SRVC_NM,  ACTV_IND) 
    VALUES('kimAttr5', 'kimAttr5', 'Attribute 5', 'groupTypeService',  'Y')
/
INSERT INTO KR_KIM_ATTRIBUTE_T(KIM_ATTRIB_ID, OBJ_ID, ATTRIB_NM, SRVC_NM,  ACTV_IND) 
    VALUES('kimAttr6', 'kimAttr6', 'Attribute 6', 'permTypeService',  'Y')
/
INSERT INTO KR_KIM_ATTRIBUTE_T(KIM_ATTRIB_ID, OBJ_ID, ATTRIB_NM, SRVC_NM,  ACTV_IND) 
    VALUES('kimAttr7', 'kimAttr7', 'Attribute 7', 'permTypeService',  'Y')
/
INSERT INTO KR_KIM_ATTRIBUTE_T(KIM_ATTRIB_ID, OBJ_ID, ATTRIB_NM, SRVC_NM,  ACTV_IND) 
    VALUES('kimAttr8', 'kimAttr8', 'Attribute 8', 'permTypeService',  'Y')
/
INSERT INTO KR_KIM_ATTRIBUTE_T(KIM_ATTRIB_ID, OBJ_ID, ATTRIB_NM, SRVC_NM,  ACTV_IND) 
    VALUES('kimAttr9', 'kimAttr9', 'Attribute 9', 'responsibilityTypeService',  'Y')
/
INSERT INTO KR_KIM_ATTRIBUTE_T(KIM_ATTRIB_ID, OBJ_ID, ATTRIB_NM, SRVC_NM,  ACTV_IND) 
    VALUES('kimAttr10', 'kimAttr10', 'Attribute 10', 'responsibilityTypeService',  'Y')
/
COMMIT
/


INSERT INTO KR_KIM_TYPE_ATTRIBUTE_T(KIM_TYPE_ATTRIB_ID, OBJ_ID, KIM_TYPE_ID, KIM_ATTRIB_ID,  ACTV_IND) 
    VALUES('kimTpAttr1', 'kimTpAttr1', 'roleType1', 'kimAttr1',  'Y')
/
INSERT INTO KR_KIM_TYPE_ATTRIBUTE_T(KIM_TYPE_ATTRIB_ID, OBJ_ID, KIM_TYPE_ID, KIM_ATTRIB_ID,  ACTV_IND) 
    VALUES('kimTpAttr2', 'kimTpAttr2', 'roleType2', 'kimAttr2',  'Y')
/
INSERT INTO KR_KIM_TYPE_ATTRIBUTE_T(KIM_TYPE_ATTRIB_ID, OBJ_ID, KIM_TYPE_ID, KIM_ATTRIB_ID,  ACTV_IND) 
    VALUES('kimTpAttr4', 'kimTpAttr4', 'groupType1', 'kimAttr4',  'Y')
/
INSERT INTO KR_KIM_TYPE_ATTRIBUTE_T(KIM_TYPE_ATTRIB_ID, OBJ_ID, KIM_TYPE_ID, KIM_ATTRIB_ID,  ACTV_IND) 
    VALUES('kimTpAttr5', 'kimTpAttr5', 'groupType2', 'kimAttr5',  'Y')
/
INSERT INTO KR_KIM_TYPE_ATTRIBUTE_T(KIM_TYPE_ATTRIB_ID, OBJ_ID, KIM_TYPE_ID, KIM_ATTRIB_ID,  ACTV_IND) 
    VALUES('kimTpAttr6', 'kimTpAttr6', 'permType1', 'kimAttr6',  'Y')
/
INSERT INTO KR_KIM_TYPE_ATTRIBUTE_T(KIM_TYPE_ATTRIB_ID, OBJ_ID, KIM_TYPE_ID, KIM_ATTRIB_ID,  ACTV_IND) 
    VALUES('kimTpAttr7', 'kimTpAttr7', 'permType2', 'kimAttr7',  'Y')
/
INSERT INTO KR_KIM_TYPE_ATTRIBUTE_T(KIM_TYPE_ATTRIB_ID, OBJ_ID, KIM_TYPE_ID, KIM_ATTRIB_ID,  ACTV_IND) 
    VALUES('kimTpAttr8', 'kimTpAttr8', 'permType3', 'kimAttr8',  'Y')
/
INSERT INTO KR_KIM_TYPE_ATTRIBUTE_T(KIM_TYPE_ATTRIB_ID, OBJ_ID, KIM_TYPE_ID, KIM_ATTRIB_ID,  ACTV_IND) 
    VALUES('kimTpAttr9', 'kimTpAttr9', 'rspType1', 'kimAttr9',  'Y')
/
INSERT INTO KR_KIM_TYPE_ATTRIBUTE_T(KIM_TYPE_ATTRIB_ID, OBJ_ID, KIM_TYPE_ID, KIM_ATTRIB_ID,  ACTV_IND) 
    VALUES('kimTpAttr10', 'kimTpAttr10', 'rspType2', 'kimAttr10',  'Y')
/
COMMIT
/



INSERT INTO KR_KIM_GROUP_T(GRP_ID, OBJ_ID, GRP_NM, NMSPC_CD, GRP_DESC, TYP_ID, ACTV_IND) 
    VALUES('g1', 'g1', 'topgroup', 'TEST', 'Top-level group', 'groupType1', 'Y')
/
INSERT INTO KR_KIM_GROUP_T(GRP_ID, OBJ_ID, GRP_NM, NMSPC_CD, GRP_DESC, TYP_ID, ACTV_IND) 
    VALUES('g2', 'g2', 'middlegroup', 'TEST', 'middle-level group', 'groupType2', 'Y')
/
INSERT INTO KR_KIM_GROUP_T(GRP_ID, OBJ_ID, GRP_NM, NMSPC_CD, GRP_DESC, TYP_ID, ACTV_IND) 
    VALUES('g3', 'g3', 'bottomgroup', 'TEST', 'Bottom-level group', 'groupType1', 'Y')
/
INSERT INTO KR_KIM_GROUP_T(GRP_ID, OBJ_ID, GRP_NM, NMSPC_CD, GRP_DESC, TYP_ID, ACTV_IND) 
    VALUES('g4', 'g4', 'bottominactivegroup', 'TEST', 'Bottom-level group (inactive', 'groupType2', 'N')
/
COMMIT
/
