Z-Archive » Maybank Projects » M2U UPASS Project

--------------------------------------------------------

--  File created - Friday-July-19-2013   

--------------------------------------------------------

Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('NOTIF_ALERT','5', EMPTY_CLOB(),1,1);

Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('NOTIF_ALERT','1', EMPTY_CLOB(),2,0);

Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('NOTIF_ALERT','1', EMPTY_CLOB(),3,0);

Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('NOTIF_ALERT','1', EMPTY_CLOB(),0,0);

Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_EXPIRY_DAY','30', EMPTY_CLOB(),3,0);

Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_EXPIRY_DAY','30', EMPTY_CLOB(),4,0);

Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_EXPIRY_DAY','30', EMPTY_CLOB(),5,0);

Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_EXPIRY_DAY','30', EMPTY_CLOB(),1,1);

Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_EXPIRY_DAY','31', EMPTY_CLOB(),2,0);

Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_GENERATION','5', EMPTY_CLOB(),3,0);

Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_GENERATION','5', EMPTY_CLOB(),4,0);

Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_GENERATION','5', EMPTY_CLOB(),5,0);

Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_GENERATION','12', EMPTY_CLOB(),1,1);

Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_GENERATION','5', EMPTY_CLOB(),2,0);

Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('USER_DORMANT_PERIOD','30', EMPTY_CLOB(),3,0);

Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('USER_DORMANT_PERIOD','30', EMPTY_CLOB(),1,1);

Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('USER_DORMANT_PERIOD','30', EMPTY_CLOB(),2,0);

Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('USER_DORMANT_PERIOD','0', EMPTY_CLOB(),0,0);

Insert into M2U_UPASS_CI.TB_AM_USER (U_USER_ID,U_USER_ALIAS,U_USER_TYPE,U_USER_DESC,U_DATE_CREATED,U_DATE_LAST_USED,U_USE_COUNT,U_DATE_LAST_ACT,U_DATE_LAST_LOCK,U_USER_STATE,U_DATE_LOCK_FROM,U_DATE_LOCK_TO,P_PASSWD_CIPHERTEXT,P_PASSWD_STATE,P_DATE_GENERATED,P_DATE_FIRST_USED,P_DATE_LAST_USED,P_USE_COUNT,P_ERROR_COUNT,P_EXPIRED_STATUS,P_DATE_EXPIRED,U_APPLICATION_ID) values (1,'root',0,'Root ID',to_date('18-MAY-10','DD-MON-RR'),to_date('30-JUN-11','DD-MON-RR'),19,null,null,0,null,null,'1408A0F64A991CE378292A7EFB4B7B84DF7F9D98114C8E6F63C4758F062F989D',0,to_date('18-MAY-10','DD-MON-RR'),to_date('18-MAY-10','DD-MON-RR'),to_date('30-JUN-11','DD-MON-RR'),19,0,1,null,0);

Insert into M2U_UPASS_CI.TB_AM_USER (U_USER_ID,U_USER_ALIAS,U_USER_TYPE,U_USER_DESC,U_DATE_CREATED,U_DATE_LAST_USED,U_USE_COUNT,U_DATE_LAST_ACT,U_DATE_LAST_LOCK,U_USER_STATE,U_DATE_LOCK_FROM,U_DATE_LOCK_TO,P_PASSWD_CIPHERTEXT,P_PASSWD_STATE,P_DATE_GENERATED,P_DATE_FIRST_USED,P_DATE_LAST_USED,P_USE_COUNT,P_ERROR_COUNT,P_EXPIRED_STATUS,P_DATE_EXPIRED,U_APPLICATION_ID) values (12,'UpassAdmin',1,'Admin',to_date('26-NOV-10','DD-MON-RR'),to_date('22-APR-13','DD-MON-RR'),3256,null,to_date('10-DEC-12','DD-MON-RR'),0,to_date('10-DEC-12','DD-MON-RR'),to_date('10-DEC-12','DD-MON-RR'),'7AABD6A7DF0B1F24A1996D57DD6E7ADA35ED56CA884996E4205C722F3EC139D6',0,to_date('26-NOV-10','DD-MON-RR'),to_date('26-NOV-10','DD-MON-RR'),to_date('09-MAY-13','DD-MON-RR'),4529,0,1,null,0);

Insert into M2U_UPASS_CI.TB_AM_USER (U_USER_ID,U_USER_ALIAS,U_USER_TYPE,U_USER_DESC,U_DATE_CREATED,U_DATE_LAST_USED,U_USE_COUNT,U_DATE_LAST_ACT,U_DATE_LAST_LOCK,U_USER_STATE,U_DATE_LOCK_FROM,U_DATE_LOCK_TO,P_PASSWD_CIPHERTEXT,P_PASSWD_STATE,P_DATE_GENERATED,P_DATE_FIRST_USED,P_DATE_LAST_USED,P_USE_COUNT,P_ERROR_COUNT,P_EXPIRED_STATUS,P_DATE_EXPIRED,U_APPLICATION_ID) values (57,'administrator',1,'MSS Admin',to_date('01-DEC-10','DD-MON-RR'),to_date('05-APR-13','DD-MON-RR'),14477,to_date('05-APR-13','DD-MON-RR'),to_date('05-APR-13','DD-MON-RR'),0,to_date('05-APR-13','DD-MON-RR'),to_date('05-APR-13','DD-MON-RR'),'64535FE6B9714612F18632CD33A2C2864DAA4EE1D06284FCA66D7DC1DD4689F8',0,to_date('01-DEC-10','DD-MON-RR'),to_date('01-DEC-10','DD-MON-RR'),to_date('09-MAY-13','DD-MON-RR'),17738,0,1,null,0);

Insert into M2U_UPASS_CI.TB_AM_USER (U_USER_ID,U_USER_ALIAS,U_USER_TYPE,U_USER_DESC,U_DATE_CREATED,U_DATE_LAST_USED,U_USE_COUNT,U_DATE_LAST_ACT,U_DATE_LAST_LOCK,U_USER_STATE,U_DATE_LOCK_FROM,U_DATE_LOCK_TO,P_PASSWD_CIPHERTEXT,P_PASSWD_STATE,P_DATE_GENERATED,P_DATE_FIRST_USED,P_DATE_LAST_USED,P_USE_COUNT,P_ERROR_COUNT,P_EXPIRED_STATUS,P_DATE_EXPIRED,U_APPLICATION_ID) values (100,'ibuser1',2,'Description',to_date('15-DEC-10','DD-MON-RR'),null,0,null,null,0,null,null,'31FC33E8DDFFE672C0975A8D3C9BF8AFE8F0DA511E70452514D3491190CA0E4F',0,to_date('15-DEC-10','DD-MON-RR'),null,null,0,0,1,null,1);

Insert into M2U_UPASS_CI.TB_AM_USER (U_USER_ID,U_USER_ALIAS,U_USER_TYPE,U_USER_DESC,U_DATE_CREATED,U_DATE_LAST_USED,U_USE_COUNT,U_DATE_LAST_ACT,U_DATE_LAST_LOCK,U_USER_STATE,U_DATE_LOCK_FROM,U_DATE_LOCK_TO,P_PASSWD_CIPHERTEXT,P_PASSWD_STATE,P_DATE_GENERATED,P_DATE_FIRST_USED,P_DATE_LAST_USED,P_USE_COUNT,P_ERROR_COUNT,P_EXPIRED_STATUS,P_DATE_EXPIRED,U_APPLICATION_ID) values (101,'ibuser2',2,'Description',to_date('15-DEC-10','DD-MON-RR'),null,0,null,null,0,null,null,'9382596D75FDF7DB48FA6BD0F3EB41587331F4340F5A3656D2F886406F290022',0,to_date('15-DEC-10','DD-MON-RR'),null,null,0,0,1,null,2);

Insert into M2U_UPASS_CI.TB_AM_USER (U_USER_ID,U_USER_ALIAS,U_USER_TYPE,U_USER_DESC,U_DATE_CREATED,U_DATE_LAST_USED,U_USE_COUNT,U_DATE_LAST_ACT,U_DATE_LAST_LOCK,U_USER_STATE,U_DATE_LOCK_FROM,U_DATE_LOCK_TO,P_PASSWD_CIPHERTEXT,P_PASSWD_STATE,P_DATE_GENERATED,P_DATE_FIRST_USED,P_DATE_LAST_USED,P_USE_COUNT,P_ERROR_COUNT,P_EXPIRED_STATUS,P_DATE_EXPIRED,U_APPLICATION_ID) values (102,'ibuser3',2,'Description',to_date('15-DEC-10','DD-MON-RR'),null,0,null,null,0,null,null,'BA2D69FB001B6A21FE5005528E8CFEEEA6C939D47E0CD383DD0D61295848FD89',0,to_date('15-DEC-10','DD-MON-RR'),null,null,0,0,1,null,3);

Insert into M2U_UPASS_CI.TB_AM_USER (U_USER_ID,U_USER_ALIAS,U_USER_TYPE,U_USER_DESC,U_DATE_CREATED,U_DATE_LAST_USED,U_USE_COUNT,U_DATE_LAST_ACT,U_DATE_LAST_LOCK,U_USER_STATE,U_DATE_LOCK_FROM,U_DATE_LOCK_TO,P_PASSWD_CIPHERTEXT,P_PASSWD_STATE,P_DATE_GENERATED,P_DATE_FIRST_USED,P_DATE_LAST_USED,P_USE_COUNT,P_ERROR_COUNT,P_EXPIRED_STATUS,P_DATE_EXPIRED,U_APPLICATION_ID) values (103,'ibuser4',2,'Description',to_date('15-DEC-10','DD-MON-RR'),null,0,null,null,0,null,null,'98C3D7E8CD74B22374703C31D182E56355B6830D5B648E8202883565881A88F6',0,to_date('15-DEC-10','DD-MON-RR'),null,null,0,0,1,null,4);

Insert into M2U_UPASS_CI.TB_AM_USER (U_USER_ID,U_USER_ALIAS,U_USER_TYPE,U_USER_DESC,U_DATE_CREATED,U_DATE_LAST_USED,U_USE_COUNT,U_DATE_LAST_ACT,U_DATE_LAST_LOCK,U_USER_STATE,U_DATE_LOCK_FROM,U_DATE_LOCK_TO,P_PASSWD_CIPHERTEXT,P_PASSWD_STATE,P_DATE_GENERATED,P_DATE_FIRST_USED,P_DATE_LAST_USED,P_USE_COUNT,P_ERROR_COUNT,P_EXPIRED_STATUS,P_DATE_EXPIRED,U_APPLICATION_ID) values (104,'ibuser5',2,'Description',to_date('15-DEC-10','DD-MON-RR'),null,0,null,null,0,null,null,'19264C925BB223D518D9284441353949FDA028FAABA3153DBA9752C3C89A7C28',0,to_date('15-DEC-10','DD-MON-RR'),null,null,0,0,1,null,5);

Insert into M2U_UPASS_CI.TB_AM_USER (U_USER_ID,U_USER_ALIAS,U_USER_TYPE,U_USER_DESC,U_DATE_CREATED,U_DATE_LAST_USED,U_USE_COUNT,U_DATE_LAST_ACT,U_DATE_LAST_LOCK,U_USER_STATE,U_DATE_LOCK_FROM,U_DATE_LOCK_TO,P_PASSWD_CIPHERTEXT,P_PASSWD_STATE,P_DATE_GENERATED,P_DATE_FIRST_USED,P_DATE_LAST_USED,P_USE_COUNT,P_ERROR_COUNT,P_EXPIRED_STATUS,P_DATE_EXPIRED,U_APPLICATION_ID) values (105,'ibuser6',2,'Description',to_date('15-DEC-10','DD-MON-RR'),null,0,null,null,0,null,null,'BD4CF661D7EEBC5F4F9DA263C5F40D6ED7E3B260',0,to_date('15-DEC-10','DD-MON-RR'),null,null,0,0,1,null,null);

Insert into M2U_UPASS_CI.TB_AM_USER (U_USER_ID,U_USER_ALIAS,U_USER_TYPE,U_USER_DESC,U_DATE_CREATED,U_DATE_LAST_USED,U_USE_COUNT,U_DATE_LAST_ACT,U_DATE_LAST_LOCK,U_USER_STATE,U_DATE_LOCK_FROM,U_DATE_LOCK_TO,P_PASSWD_CIPHERTEXT,P_PASSWD_STATE,P_DATE_GENERATED,P_DATE_FIRST_USED,P_DATE_LAST_USED,P_USE_COUNT,P_ERROR_COUNT,P_EXPIRED_STATUS,P_DATE_EXPIRED,U_APPLICATION_ID) values (106,'ibuser7',2,'Description',to_date('15-DEC-10','DD-MON-RR'),null,0,null,null,0,null,null,'CFE07A6E720E205E6210BDBA5ED1473845856F56',0,to_date('15-DEC-10','DD-MON-RR'),null,null,0,0,1,null,null);

Insert into M2U_UPASS_CI.TB_AM_USERMAS (M_USER_ALIAS,M_USER_ID) values ('UpassAdmin',12);

Insert into M2U_UPASS_CI.TB_AM_USERMAS (M_USER_ALIAS,M_USER_ID) values ('administrator',57);

Insert into M2U_UPASS_CI.ADMIN_USER_PROFILE (USER_ID,ROLE_ID,GROUP_ID,USER_NAME,USER_DOB,USER_EMAIL,USER_GENDER,USER_RACE,USER_OFFICE_NUMBER,USER_MOBILE_NUMBER,CREATED_BY,UPDATED_BY,UPDATED_DATE,LAST_LOGIN_DATE,FORCE_RESET,MK_PENDING,LAST_IP_ADDRESS,LAST_HOST_NAME,USER_ADMIN_ROLE) values (12,1,1,'Tester number 1','30021987','mail@mail.com','M',null,'0312345678','0128888888',0,12,to_date('23/04/2013','DD/MM/RRRR'),to_date('11/07/2013','DD/MM/RRRR'),0,0,'172.16.23.132','172.16.23.132',null);

Insert into M2U_UPASS_CI.ADMIN_GROUP (GROUP_ID,GROUP_NAME,GROUP_DESCRIPTION,GROUP_CREATED_BY,GROUP_UPDATED_BY,GROUP_CREATION_DATE,GROUP_UPDATED_DATE,CATEGORY,GROUP_LVL,MODE_TYPE,MK_PENDING) values (0,'Ungrouped','No group',12,12,to_date('12/09/2011','DD/MM/RRRR'),to_date('12/09/2011','DD/MM/RRRR'),1,9,'1',0);

Insert into M2U_UPASS_CI.ADMIN_GROUP (GROUP_ID,GROUP_NAME,GROUP_DESCRIPTION,GROUP_CREATED_BY,GROUP_UPDATED_BY,GROUP_CREATION_DATE,GROUP_UPDATED_DATE,CATEGORY,GROUP_LVL,MODE_TYPE,MK_PENDING) values (1,'System Administrator','System ID',0,12,to_date('05/12/2010','DD/MM/RRRR'),to_date('06/12/2010','DD/MM/RRRR'),1,0,'1',0);

Insert into M2U_UPASS_CI.ADMIN_NAVIGATION (NODE_ID,PARENT_ID,NODE_NAME,NODE_DESCRIPTION,NODE_TYPE,NODE_STATUS,NODE_CODE,NODE_DISPLAY_ORDER,PAGE_PATH,NODE_CREATED_BY,NODE_UPDATED_BY,NODE_CREATION_DATE,NODE_UPDATED_DATE,CATEGORY,NODE_SYSTEM,MK_PENDING) values (19,null,'USS Navigation','Admin Navigation','0','0','ADMIN',1,null,12,822,to_timestamp('15/08/2011 00:00:00.000000000','DD/MM/RRRR HH24:MI:SSXFF'),to_timestamp('06/12/2011 00:00:00.000000000','DD/MM/RRRR HH24:MI:SSXFF'),1,'IBAM',0);

Insert into M2U_UPASS_CI.ADMIN_NAVIGATION (NODE_ID,PARENT_ID,NODE_NAME,NODE_DESCRIPTION,NODE_TYPE,NODE_STATUS,NODE_CODE,NODE_DISPLAY_ORDER,PAGE_PATH,NODE_CREATED_BY,NODE_UPDATED_BY,NODE_CREATION_DATE,NODE_UPDATED_DATE,CATEGORY,NODE_SYSTEM,MK_PENDING) values (7,19,'Admin Group Maintenance ','Assign User Role to a Specific Group of Admin User','1','0','SSSSAGRP',2,'/ss103/groupEnquiryMain.do',6,12,to_timestamp('06/12/2010 00:00:00.000000000','DD/MM/RRRR HH24:MI:SSXFF'),to_timestamp('30/10/2011 00:00:00.000000000','DD/MM/RRRR HH24:MI:SSXFF'),1,'IBAM',0);

Insert into M2U_UPASS_CI.ADMIN_NAVIGATION (NODE_ID,PARENT_ID,NODE_NAME,NODE_DESCRIPTION,NODE_TYPE,NODE_STATUS,NODE_CODE,NODE_DISPLAY_ORDER,PAGE_PATH,NODE_CREATED_BY,NODE_UPDATED_BY,NODE_CREATION_DATE,NODE_UPDATED_DATE,CATEGORY,NODE_SYSTEM,MK_PENDING) values (3,19,'Admin User Maintenance','Maintain IBAM Admin users','1','0','SSSSAENQ',3,'/ss102/userEnquiryScreen.do',6,12,to_timestamp('09/11/2010 00:00:00.000000000','DD/MM/RRRR HH24:MI:SSXFF'),to_timestamp('23/10/2011 00:00:00.000000000','DD/MM/RRRR HH24:MI:SSXFF'),1,'IBAM',0);

Insert into M2U_UPASS_CI.ADMIN_NAVIGATION (NODE_ID,PARENT_ID,NODE_NAME,NODE_DESCRIPTION,NODE_TYPE,NODE_STATUS,NODE_CODE,NODE_DISPLAY_ORDER,PAGE_PATH,NODE_CREATED_BY,NODE_UPDATED_BY,NODE_CREATION_DATE,NODE_UPDATED_DATE,CATEGORY,NODE_SYSTEM,MK_PENDING) values (6,19,'Menu Maintenance','To maintain IBAM Navigation','1','0','SSSSNAVI',4,'/ss100/navigationEnquiryMain.do',6,822,to_timestamp('09/11/2010 00:00:00.000000000','DD/MM/RRRR HH24:MI:SSXFF'),to_timestamp('06/12/2011 00:00:00.000000000','DD/MM/RRRR HH24:MI:SSXFF'),1,'IBAM',0);

Insert into M2U_UPASS_CI.ADMIN_NAVIGATION (NODE_ID,PARENT_ID,NODE_NAME,NODE_DESCRIPTION,NODE_TYPE,NODE_STATUS,NODE_CODE,NODE_DISPLAY_ORDER,PAGE_PATH,NODE_CREATED_BY,NODE_UPDATED_BY,NODE_CREATION_DATE,NODE_UPDATED_DATE,CATEGORY,NODE_SYSTEM,MK_PENDING) values (1,19,'Customer Enquiry','RIB User Enquiry','1','0','SSSSUENQ',5,'/ss112/searchUser.do',6,12,to_timestamp('09/11/2010 00:00:00.000000000','DD/MM/RRRR HH24:MI:SSXFF'),to_timestamp('27/07/2011 00:00:00.000000000','DD/MM/RRRR HH24:MI:SSXFF'),1,'IBAM',0);

Insert into M2U_UPASS_CI.ADMIN_NAVIGATION (NODE_ID,PARENT_ID,NODE_NAME,NODE_DESCRIPTION,NODE_TYPE,NODE_STATUS,NODE_CODE,NODE_DISPLAY_ORDER,PAGE_PATH,NODE_CREATED_BY,NODE_UPDATED_BY,NODE_CREATION_DATE,NODE_UPDATED_DATE,CATEGORY,NODE_SYSTEM,MK_PENDING) values (8,19,'USS Audit Log','Audit Log','1','0','SSSSALOG',6,'/ss104/auditTrailMain.do',6,12,to_timestamp('06/12/2010 00:00:00.000000000','DD/MM/RRRR HH24:MI:SSXFF'),to_timestamp('23/10/2011 00:00:00.000000000','DD/MM/RRRR HH24:MI:SSXFF'),1,'IBAM',0);

Insert into M2U_UPASS_CI.ADMIN_NAVIGATION (NODE_ID,PARENT_ID,NODE_NAME,NODE_DESCRIPTION,NODE_TYPE,NODE_STATUS,NODE_CODE,NODE_DISPLAY_ORDER,PAGE_PATH,NODE_CREATED_BY,NODE_UPDATED_BY,NODE_CREATION_DATE,NODE_UPDATED_DATE,CATEGORY,NODE_SYSTEM,MK_PENDING) values (9,19,'Change Your Password','Change Password','1','0','SSSSCPWD',7,'/ss102/changePassword.do',6,12,to_timestamp('06/12/2010 00:00:00.000000000','DD/MM/RRRR HH24:MI:SSXFF'),to_timestamp('23/10/2011 00:00:00.000000000','DD/MM/RRRR HH24:MI:SSXFF'),1,'IBAM',0);

Insert into M2U_UPASS_CI.ADMIN_NAVIGATION (NODE_ID,PARENT_ID,NODE_NAME,NODE_DESCRIPTION,NODE_TYPE,NODE_STATUS,NODE_CODE,NODE_DISPLAY_ORDER,PAGE_PATH,NODE_CREATED_BY,NODE_UPDATED_BY,NODE_CREATION_DATE,NODE_UPDATED_DATE,CATEGORY,NODE_SYSTEM,MK_PENDING) values (35,19,'Upass USS Maintenance','Settings','1','0','SSSSSETT',8,'/ss221/settings.do',1,12,to_timestamp('17/02/2012 00:00:00.000000000','DD/MM/RRRR HH24:MI:SSXFF'),to_timestamp('30/06/2013 00:00:00.000000000','DD/MM/RRRR HH24:MI:SSXFF'),1,'IBAM',0);

Insert into M2U_UPASS_CI.ADMIN_NAVIGATION (NODE_ID,PARENT_ID,NODE_NAME,NODE_DESCRIPTION,NODE_TYPE,NODE_STATUS,NODE_CODE,NODE_DISPLAY_ORDER,PAGE_PATH,NODE_CREATED_BY,NODE_UPDATED_BY,NODE_CREATION_DATE,NODE_UPDATED_DATE,CATEGORY,NODE_SYSTEM,MK_PENDING) values (36,19,'Application Admin Maintenance','To Maintain Application Admin','1','0','SSSSAUM',9,'/ss223/appUserEnquiryMain.do',1,12,to_timestamp('17/02/2012 00:00:00.000000000','DD/MM/RRRR HH24:MI:SSXFF'),to_timestamp('30/06/2013 00:00:00.000000000','DD/MM/RRRR HH24:MI:SSXFF'),1,'IBAM',0);

Insert into M2U_UPASS_CI.ADMIN_ROLE (ROLE_ID,ROLE_NAME,ROLE_DESCRIPTION,ROLE_CREATED_BY,ROLE_UPDATED_BY,ROLE_CREATION_DATE,ROLE_UPDATED_DATE) values (0,'Test role','Testing Description for this role',0,0,to_timestamp('10/10/2011 00:00:00.000000000','DD/MM/RRRR HH24:MI:SSXFF'),to_date('10/10/2011','DD/MM/RRRR'));

Insert into M2U_UPASS_CI.ADMIN_ROLE (ROLE_ID,ROLE_NAME,ROLE_DESCRIPTION,ROLE_CREATED_BY,ROLE_UPDATED_BY,ROLE_CREATION_DATE,ROLE_UPDATED_DATE) values (1,'Super Admin','Super Administrator',1,1,to_timestamp('05/12/2010 00:00:00.000000000','DD/MM/RRRR HH24:MI:SSXFF'),to_date('05/12/2010','DD/MM/RRRR'));

Insert into M2U_UPASS_CI.ADMIN_ROLE (ROLE_ID,ROLE_NAME,ROLE_DESCRIPTION,ROLE_CREATED_BY,ROLE_UPDATED_BY,ROLE_CREATION_DATE,ROLE_UPDATED_DATE) values (2,'Admin','Admin',1,1,to_timestamp('15/12/2010 00:00:00.000000000','DD/MM/RRRR HH24:MI:SSXFF'),null);

Insert into M2U_UPASS_CI.IB_USER (USER_ID,ACCOUNT_ID,USER_ALIAS,PASSWORD,USER_STATE,MODIF_TIME,CREATION_DATE) values (12,0,'administrator',null,0,to_date('05/12/2010','DD/MM/RRRR'),to_date('05/12/2010','DD/MM/RRRR'));