Revision 58:077576134e91

View differences:

test/resources/db-scripts/m2u-upass-ci-oracle.sql
902 902
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_MIN_LENGTH','9', EMPTY_CLOB(),2,0);
903 903
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_MIN_LENGTH','1', EMPTY_CLOB(),0,0);
904 904
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_PATTERN','(?=.*[0-9])(?=.*[a-z])(?=.*[A-Z]).{8,12}', EMPTY_CLOB(),3,0);
905
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_PATTERN','(?=.*\\d)(?=.*[a-zA-Z<>''%;&+]).{8,16}', EMPTY_CLOB(),1,1);
905
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_PATTERN','(?=.*[0-9])(?=.*[a-z])(?=.*[A-Z]).{8,12}', EMPTY_CLOB(),1,1);
906 906
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_PATTERN','(?=.*[0-9])(?=.*[a-z])(?=.*[A-Z]).{8,12}', EMPTY_CLOB(),2,0);
907 907
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_PATTERN','(?=.*[0-9])(?=.*[a-z])(?=.*[A-Z]).{8,12}', EMPTY_CLOB(),4,0);
908 908
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_PATTERN','(?=.*[0-9])(?=.*[a-z])(?=.*[A-Z]).{8,12}', EMPTY_CLOB(),5,0);
......
923 923
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);
924 924
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);
925 925
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);
926
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('USERNAME_PATTERN','^[a-zA-Z0-9_-]{6,16}$', EMPTY_CLOB(),3,0);
927
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('USERNAME_PATTERN','^[a-zA-Z0-9_-]{6,16}$', EMPTY_CLOB(),4,0);
928
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('USERNAME_PATTERN','^[a-zA-Z0-9_-]{6,16}$', EMPTY_CLOB(),5,0);
929
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('USERNAME_PATTERN','^[a-zA-Z0-9_-]{6,16}$', EMPTY_CLOB(),1,1);
930
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('USERNAME_PATTERN','^[a-zA-Z0-9_-]{6,16}$', EMPTY_CLOB(),2,0);
931
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('USERNAME_PATTERN','^[a-zA-Z0-9_-]{6,16}$', EMPTY_CLOB(),0,0);
926
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('USERNAME_PATTERN','^[a-zA-Z0-9\\._-]{6,16}$', EMPTY_CLOB(),3,0);
927
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('USERNAME_PATTERN','^[a-zA-Z0-9\\._-]{6,16}$', EMPTY_CLOB(),4,0);
928
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('USERNAME_PATTERN','^[a-zA-Z0-9\\._-]{6,16}$', EMPTY_CLOB(),5,0);
929
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('USERNAME_PATTERN','^[a-zA-Z0-9\\._-]{6,16}$', EMPTY_CLOB(),1,1);
930
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('USERNAME_PATTERN','^[a-zA-Z0-9\\._-]{6,16}$', EMPTY_CLOB(),2,0);
931
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('USERNAME_PATTERN','^[a-zA-Z0-9\\._-]{6,16}$', EMPTY_CLOB(),0,0);
932 932

  
933 933

  
934 934

  
......
1136 1136
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'),'E4B812847959F723BCC8D4DA5561F0F8F01FC94B3A8275F840F6AA4811F40940',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);
1137 1137
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 (15,'ibuser',2,' ',to_date('26-NOV-10','DD-MON-RR'),to_date('13-OCT-11','DD-MON-RR'),10766,to_date('13-OCT-11','DD-MON-RR'),to_date('13-OCT-11','DD-MON-RR'),0,null,null,'4E844A73445B9AC9E67AF51BF628E492E7F6951B',0,to_date('26-NOV-10','DD-MON-RR'),to_date('26-NOV-10','DD-MON-RR'),to_date('13-OCT-11','DD-MON-RR'),10713,0,1,null,null);
1138 1138
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'),'CD0661AA22CF155A8F55780AB6693FCF09FBCEBFC30666B1C30A4F297E375D4E',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);
1139
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 (65,'bernard',2,'Description',to_date('02-DEC-10','DD-MON-RR'),to_date('12-DEC-10','DD-MON-RR'),14,null,null,0,null,null,'418F39E0FB8C4C8D78DCC77A3E4FE6B6B65E3B81',0,to_date('02-DEC-10','DD-MON-RR'),to_date('02-DEC-10','DD-MON-RR'),to_date('08-DEC-10','DD-MON-RR'),9,0,1,null,null);
1139
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 (65,'bernardxx',2,'Description',to_date('02-DEC-10','DD-MON-RR'),to_date('12-DEC-10','DD-MON-RR'),14,null,null,0,null,null,'418F39E0FB8C4C8D78DCC77A3E4FE6B6B65E3B81',0,to_date('02-DEC-10','DD-MON-RR'),to_date('02-DEC-10','DD-MON-RR'),to_date('08-DEC-10','DD-MON-RR'),9,0,1,null,null);
1140 1140
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 (66,'tester02',2,'MSS User',to_date('06-DEC-10','DD-MON-RR'),null,0,null,null,0,null,null,'FD3D669C12901B84B8FDAAD90DB47CE1AAB4E7BC',0,to_date('06-DEC-10','DD-MON-RR'),null,null,0,0,1,null,null);
1141 1141
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 (67,'mssuser',2,'MSS User',to_date('06-DEC-10','DD-MON-RR'),null,0,null,null,0,null,null,'668B0F7060D5CBA0C5553814C69693F92ED90A42',0,to_date('06-DEC-10','DD-MON-RR'),null,null,0,0,1,null,null);
1142 1142
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 (73,'mssuser2',2,'MSS User',to_date('06-DEC-10','DD-MON-RR'),null,0,null,null,0,null,null,'19731A9F4D8F0A449A55128F93C08EAC2B2F7192',0,to_date('06-DEC-10','DD-MON-RR'),null,null,0,0,1,null,null);
......
1156 1156
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 (91,'weewee',2,'Description',to_date('14-DEC-10','DD-MON-RR'),to_date('07-JAN-11','DD-MON-RR'),2,null,null,0,null,null,'CF272CAB37CFDCBABAD737BDF15AACB5D94FF175',0,to_date('14-DEC-10','DD-MON-RR'),to_date('14-DEC-10','DD-MON-RR'),to_date('07-JAN-11','DD-MON-RR'),2,0,1,null,null);
1157 1157
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 (92,'qwerty123',2,'Description',to_date('14-DEC-10','DD-MON-RR'),to_date('14-DEC-10','DD-MON-RR'),4,null,null,0,null,null,'D78B42496B2E223CA596B1FF5167E1362C894500',0,to_date('14-DEC-10','DD-MON-RR'),null,null,0,0,1,null,null);
1158 1158
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 (93,'qwerty',2,'Description',to_date('14-DEC-10','DD-MON-RR'),to_date('15-DEC-10','DD-MON-RR'),1,null,null,0,null,null,'F9776C97F9241DD40DC80ABEC8890A8137A11B7F',0,to_date('14-DEC-10','DD-MON-RR'),null,null,0,0,1,null,null);
1159
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 (94,'penril',2,'Description',to_date('14-DEC-10','DD-MON-RR'),null,0,null,null,0,null,null,'4A76FB9C37533504647D02EDD334585137448801',0,to_date('14-DEC-10','DD-MON-RR'),null,null,0,0,1,null,null);
1159
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 (94,'penrilxx',2,'Description',to_date('14-DEC-10','DD-MON-RR'),null,0,null,null,0,null,null,'4A76FB9C37533504647D02EDD334585137448801',0,to_date('14-DEC-10','DD-MON-RR'),null,null,0,0,1,null,null);
1160 1160
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 (95,'drasy123',2,'Description',to_date('14-DEC-10','DD-MON-RR'),null,0,null,null,0,null,null,'87155181E211590D63D6DC428887FA17A456E5C2',0,to_date('14-DEC-10','DD-MON-RR'),null,null,0,0,1,null,null);
1161 1161
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 (96,'user123',2,'Description',to_date('14-DEC-10','DD-MON-RR'),to_date('14-DEC-10','DD-MON-RR'),1,null,null,0,null,null,'450CDED6E554F283A72804C46F97C6643EEA21F9',0,to_date('14-DEC-10','DD-MON-RR'),to_date('14-DEC-10','DD-MON-RR'),to_date('14-DEC-10','DD-MON-RR'),1,0,1,null,null);
1162 1162
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 (97,'user888',2,'Description',to_date('14-DEC-10','DD-MON-RR'),to_date('14-DEC-10','DD-MON-RR'),1,null,null,0,null,null,'DDBCA1C06257AFA992CF405C3F8683827596A2BC',0,to_date('14-DEC-10','DD-MON-RR'),to_date('14-DEC-10','DD-MON-RR'),to_date('14-DEC-10','DD-MON-RR'),1,0,1,null,null);
......
1280 1280
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 (974,'gabby1111',2,'iBAM User',to_date('29-MAR-12','DD-MON-RR'),to_date('29-MAR-12','DD-MON-RR'),18,to_date('29-MAR-12','DD-MON-RR'),null,0,null,null,'3B89C5B28735359EC88214B1CFE51E357C73B8EE',0,to_date('29-MAR-12','DD-MON-RR'),to_date('29-MAR-12','DD-MON-RR'),to_date('29-MAR-12','DD-MON-RR'),17,0,0,to_date('27-JUN-12','DD-MON-RR'),1);
1281 1281
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 (976,'gabbytianr',2,'iBAM User',to_date('29-MAR-12','DD-MON-RR'),to_date('29-MAR-12','DD-MON-RR'),9,to_date('29-MAR-12','DD-MON-RR'),to_date('29-MAR-12','DD-MON-RR'),0,null,null,'F4ACB2AB66C5CC9D50E6E093D8A6DDDBD984039B',0,to_date('29-MAR-12','DD-MON-RR'),to_date('29-MAR-12','DD-MON-RR'),to_date('29-MAR-12','DD-MON-RR'),7,0,0,to_date('27-JUN-12','DD-MON-RR'),1);
1282 1282
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 (977,'rayvandy',2,'iBAM User',to_date('29-MAR-12','DD-MON-RR'),to_date('29-MAR-12','DD-MON-RR'),17,to_date('29-MAR-12','DD-MON-RR'),null,0,null,null,'F85AC03CA1BDB23320663136F6E3DC783EDC5394',0,to_date('29-MAR-12','DD-MON-RR'),to_date('29-MAR-12','DD-MON-RR'),to_date('29-MAR-12','DD-MON-RR'),16,0,0,to_date('27-JUN-12','DD-MON-RR'),1);
1283
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 (979,'testing1234',2,'iBAM User',to_date('17-APR-12','DD-MON-RR'),to_date('17-APR-12','DD-MON-RR'),3,to_date('17-APR-12','DD-MON-RR'),null,0,null,null,'FA7035ACCCCE198723D18599BD5B82499A5D100B',0,to_date('17-APR-12','DD-MON-RR'),to_date('17-APR-12','DD-MON-RR'),to_date('17-APR-12','DD-MON-RR'),2,0,0,to_date('16-JUL-12','DD-MON-RR'),1);
1283
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 (979,'testing1234x',2,'iBAM User',to_date('17-APR-12','DD-MON-RR'),to_date('17-APR-12','DD-MON-RR'),3,to_date('17-APR-12','DD-MON-RR'),null,0,null,null,'FA7035ACCCCE198723D18599BD5B82499A5D100B',0,to_date('17-APR-12','DD-MON-RR'),to_date('17-APR-12','DD-MON-RR'),to_date('17-APR-12','DD-MON-RR'),2,0,0,to_date('16-JUL-12','DD-MON-RR'),1);
1284 1284
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 (981,'sittestom1',2,' ',to_date('02-AUG-12','DD-MON-RR'),to_date('03-AUG-12','DD-MON-RR'),3,to_date('03-AUG-12','DD-MON-RR'),null,0,null,null,'507E0B4D67C652C4B246662EC8D5383162F55799',0,to_date('02-AUG-12','DD-MON-RR'),to_date('03-AUG-12','DD-MON-RR'),to_date('03-AUG-12','DD-MON-RR'),2,0,1,to_date('31-OCT-12','DD-MON-RR'),null);
1285 1285
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 (982,'navitester',2,'iBAM User',to_date('26-SEP-12','DD-MON-RR'),to_date('04-JAN-13','DD-MON-RR'),543,to_date('03-JAN-13','DD-MON-RR'),null,0,null,null,'E14DC23079CCC16F268525CEC9C637B1FA708373',0,to_date('26-SEP-12','DD-MON-RR'),to_date('26-SEP-12','DD-MON-RR'),to_date('04-JAN-13','DD-MON-RR'),536,0,0,to_date('09-JAN-13','DD-MON-RR'),1);
1286 1286
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 (984,'momoadmin',2,'iBAM User',to_date('23-OCT-12','DD-MON-RR'),to_date('20-NOV-12','DD-MON-RR'),289,to_date('12-APR-13','DD-MON-RR'),to_date('12-APR-13','DD-MON-RR'),2,to_date('09-APR-13','DD-MON-RR'),to_date('10-APR-13','DD-MON-RR'),'C731B376C69F957F91DCB96835D4D07EF9D37A67',0,to_date('23-OCT-12','DD-MON-RR'),to_date('23-OCT-12','DD-MON-RR'),to_date('12-APR-13','DD-MON-RR'),292,0,0,to_date('21-JAN-13','DD-MON-RR'),1);
......
1344 1344
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 (639,'limkaien1',2,' ',to_date('07-SEP-11','DD-MON-RR'),to_date('03-AUG-12','DD-MON-RR'),46,to_date('07-SEP-11','DD-MON-RR'),null,0,null,null,'1842719DA46C29DAA501B5F96B0E6BD5CC697B68',0,to_date('07-SEP-11','DD-MON-RR'),to_date('07-SEP-11','DD-MON-RR'),to_date('03-AUG-12','DD-MON-RR'),45,0,1,null,null);
1345 1345
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 (640,'belthazor',2,' ',to_date('07-SEP-11','DD-MON-RR'),to_date('08-SEP-11','DD-MON-RR'),12,to_date('08-SEP-11','DD-MON-RR'),null,0,null,null,'B757ADB8D177F3989DB3F35EBB94258C814B4EA7',0,to_date('07-SEP-11','DD-MON-RR'),to_date('07-SEP-11','DD-MON-RR'),to_date('08-SEP-11','DD-MON-RR'),11,0,1,null,null);
1346 1346
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 (641,'mama789',2,' ',to_date('07-SEP-11','DD-MON-RR'),to_date('08-SEP-11','DD-MON-RR'),5,to_date('08-SEP-11','DD-MON-RR'),null,0,null,null,'39C66B76C7AFE4BB1144FA9D8C336BC03CF5CEB7',0,to_date('07-SEP-11','DD-MON-RR'),to_date('07-SEP-11','DD-MON-RR'),to_date('07-SEP-11','DD-MON-RR'),4,0,1,null,null);
1347
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 (642,'wolverine',2,' ',to_date('07-SEP-11','DD-MON-RR'),to_date('08-SEP-11','DD-MON-RR'),8,to_date('08-SEP-11','DD-MON-RR'),to_date('07-SEP-11','DD-MON-RR'),0,null,null,'CF45456D06E3F8D6621F651562BA23CB63D5B58D',0,to_date('07-SEP-11','DD-MON-RR'),to_date('07-SEP-11','DD-MON-RR'),to_date('07-SEP-11','DD-MON-RR'),6,0,1,null,null);
1347
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 (642,'wolverinexx',2,' ',to_date('07-SEP-11','DD-MON-RR'),to_date('08-SEP-11','DD-MON-RR'),8,to_date('08-SEP-11','DD-MON-RR'),to_date('07-SEP-11','DD-MON-RR'),0,null,null,'CF45456D06E3F8D6621F651562BA23CB63D5B58D',0,to_date('07-SEP-11','DD-MON-RR'),to_date('07-SEP-11','DD-MON-RR'),to_date('07-SEP-11','DD-MON-RR'),6,0,1,null,null);
1348 1348
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 (645,'max004',2,' ',to_date('08-SEP-11','DD-MON-RR'),to_date('29-NOV-11','DD-MON-RR'),81,to_date('29-NOV-11','DD-MON-RR'),to_date('30-OCT-11','DD-MON-RR'),0,null,null,'3FFEB05D395B9091F0E88E642C8E0422CD6EAA3C',0,to_date('08-SEP-11','DD-MON-RR'),to_date('08-SEP-11','DD-MON-RR'),to_date('29-NOV-11','DD-MON-RR'),75,0,0,to_date('28-NOV-11','DD-MON-RR'),null);
1349 1349
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 (646,'asyraf',2,'iBAM User',to_date('08-SEP-11','DD-MON-RR'),to_date('14-SEP-11','DD-MON-RR'),8,to_date('08-SEP-11','DD-MON-RR'),to_date('14-SEP-11','DD-MON-RR'),0,null,null,'04B4F18C8834B277ED97A859FA77BA487FE427EE',0,to_date('08-SEP-11','DD-MON-RR'),to_date('08-SEP-11','DD-MON-RR'),to_date('08-SEP-11','DD-MON-RR'),6,0,1,null,1);
1350 1350
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 (647,'khairul',2,'iBAM User',to_date('08-SEP-11','DD-MON-RR'),to_date('14-SEP-11','DD-MON-RR'),6,to_date('08-SEP-11','DD-MON-RR'),to_date('14-SEP-11','DD-MON-RR'),0,null,null,'FA54DC3A1162DF62C101FE23A4669E7B44EF094B',0,to_date('08-SEP-11','DD-MON-RR'),to_date('08-SEP-11','DD-MON-RR'),to_date('08-SEP-11','DD-MON-RR'),4,0,1,null,1);
......
1520 1520
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 (1338,'SNM5234',2,'Desciption',to_date('08-MAR-13','DD-MON-RR'),null,0,to_date('08-APR-13','DD-MON-RR'),to_date('08-APR-13','DD-MON-RR'),0,null,null,'364B4D4A832EE21ED44C79F81EA2A8DA72AF767F',0,to_date('08-APR-13','DD-MON-RR'),to_date('12-MAR-13','DD-MON-RR'),to_date('08-APR-13','DD-MON-RR'),7,0,0,to_date('08-APR-13','DD-MON-RR'),1);
1521 1521
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 (1339,'artu234',2,'iBAM User',to_date('14-MAR-13','DD-MON-RR'),null,0,null,null,0,null,null,'D6E57B74AE310414B2D3AAA8C3A22FE78C6A8F06',0,to_date('14-MAR-13','DD-MON-RR'),null,null,0,0,0,to_date('14-MAR-13','DD-MON-RR'),1);
1522 1522
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 (1340,'QaChecker2',2,'iBAM User',to_date('14-MAR-13','DD-MON-RR'),null,0,to_date('08-APR-13','DD-MON-RR'),null,0,null,null,'22BA0DA08EA5EEBDA18DE7BADCF6F00E60D069DE',0,to_date('08-APR-13','DD-MON-RR'),to_date('14-MAR-13','DD-MON-RR'),to_date('10-APR-13','DD-MON-RR'),47,0,0,to_date('08-APR-13','DD-MON-RR'),1);
1523
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 (1341,'penril',2,'BIB User',to_date('18-MAR-13','DD-MON-RR'),null,0,null,null,0,null,null,'5E16A58F2E8643EA815102EAB72749792D96508E',0,to_date('18-MAR-13','DD-MON-RR'),null,null,0,0,0,to_date('18-MAR-13','DD-MON-RR'),3);
1523
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 (1341,'penrilxxx',2,'BIB User',to_date('18-MAR-13','DD-MON-RR'),null,0,null,null,0,null,null,'5E16A58F2E8643EA815102EAB72749792D96508E',0,to_date('18-MAR-13','DD-MON-RR'),null,null,0,0,0,to_date('18-MAR-13','DD-MON-RR'),3);
1524 1524
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 (1342,'Sofjan',2,'iBAM User',to_date('19-MAR-13','DD-MON-RR'),null,0,to_date('15-APR-13','DD-MON-RR'),null,0,null,null,'EA0B1B43F438A0F3764D5266F0EE1C167BE5B3C9',0,to_date('15-APR-13','DD-MON-RR'),to_date('19-MAR-13','DD-MON-RR'),to_date('07-MAY-13','DD-MON-RR'),351,0,0,to_date('15-APR-13','DD-MON-RR'),1);
1525 1525
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 (1343,'SofjanCheck',2,'iBAM User',to_date('19-MAR-13','DD-MON-RR'),null,0,to_date('15-APR-13','DD-MON-RR'),null,0,null,null,'4FF8159F4704978CBE8624AF9DB31B2492572380',0,to_date('15-APR-13','DD-MON-RR'),to_date('19-MAR-13','DD-MON-RR'),to_date('07-MAY-13','DD-MON-RR'),297,0,0,to_date('15-APR-13','DD-MON-RR'),1);
1526 1526
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 (1344,'checkerUser',2,'iBAM User',to_date('20-MAR-13','DD-MON-RR'),null,0,to_date('19-APR-13','DD-MON-RR'),to_date('10-APR-13','DD-MON-RR'),0,null,null,'F613AB429A706B48736BA24D344F549E3EBCBE35',0,to_date('19-APR-13','DD-MON-RR'),to_date('20-MAR-13','DD-MON-RR'),to_date('06-MAY-13','DD-MON-RR'),83,0,0,to_date('19-APR-13','DD-MON-RR'),1);
......
1727 1727
Insert into M2U_UPASS_CI.TB_AM_USERMAS (M_USER_ALIAS,M_USER_ID) values ('bbbb12',1060);
1728 1728
Insert into M2U_UPASS_CI.TB_AM_USERMAS (M_USER_ALIAS,M_USER_ID) values ('beejacob',689);
1729 1729
Insert into M2U_UPASS_CI.TB_AM_USERMAS (M_USER_ALIAS,M_USER_ID) values ('belthazor',640);
1730
Insert into M2U_UPASS_CI.TB_AM_USERMAS (M_USER_ALIAS,M_USER_ID) values ('bernard',65);
1730
Insert into M2U_UPASS_CI.TB_AM_USERMAS (M_USER_ALIAS,M_USER_ID) values ('bernardxx',65);
1731 1731
Insert into M2U_UPASS_CI.TB_AM_USERMAS (M_USER_ALIAS,M_USER_ID) values ('bernardx',89);
1732 1732
Insert into M2U_UPASS_CI.TB_AM_USERMAS (M_USER_ALIAS,M_USER_ID) values ('bibadmin',1014);
1733 1733
Insert into M2U_UPASS_CI.TB_AM_USERMAS (M_USER_ALIAS,M_USER_ID) values ('bibchecker',1211);
......
2002 2002
Insert into M2U_UPASS_CI.TB_AM_USERMAS (M_USER_ALIAS,M_USER_ID) values ('P2000',850);
2003 2003
Insert into M2U_UPASS_CI.TB_AM_USERMAS (M_USER_ALIAS,M_USER_ID) values ('password',832);
2004 2004
Insert into M2U_UPASS_CI.TB_AM_USERMAS (M_USER_ALIAS,M_USER_ID) values ('paulchun',86);
2005
Insert into M2U_UPASS_CI.TB_AM_USERMAS (M_USER_ALIAS,M_USER_ID) values ('penril',1341);
2005
Insert into M2U_UPASS_CI.TB_AM_USERMAS (M_USER_ALIAS,M_USER_ID) values ('penrilxxx',1341);
2006 2006
Insert into M2U_UPASS_CI.TB_AM_USERMAS (M_USER_ALIAS,M_USER_ID) values ('penril1',157);
2007 2007
Insert into M2U_UPASS_CI.TB_AM_USERMAS (M_USER_ALIAS,M_USER_ID) values ('penril123',185);
2008 2008
Insert into M2U_UPASS_CI.TB_AM_USERMAS (M_USER_ALIAS,M_USER_ID) values ('penril4',189);
......
2099 2099
Insert into M2U_UPASS_CI.TB_AM_USERMAS (M_USER_ALIAS,M_USER_ID) values ('testing',754);
2100 2100
Insert into M2U_UPASS_CI.TB_AM_USERMAS (M_USER_ALIAS,M_USER_ID) values ('Testing001',125);
2101 2101
Insert into M2U_UPASS_CI.TB_AM_USERMAS (M_USER_ALIAS,M_USER_ID) values ('Testing002',131);
2102
Insert into M2U_UPASS_CI.TB_AM_USERMAS (M_USER_ALIAS,M_USER_ID) values ('testing1234',979);
2102
Insert into M2U_UPASS_CI.TB_AM_USERMAS (M_USER_ALIAS,M_USER_ID) values ('testing1234x',979);
2103 2103
Insert into M2U_UPASS_CI.TB_AM_USERMAS (M_USER_ALIAS,M_USER_ID) values ('testingdelete222',547);
2104 2104
Insert into M2U_UPASS_CI.TB_AM_USERMAS (M_USER_ALIAS,M_USER_ID) values ('testinglogin001',152);
2105 2105
Insert into M2U_UPASS_CI.TB_AM_USERMAS (M_USER_ALIAS,M_USER_ID) values ('testinglogin002',153);
......
2183 2183
Insert into M2U_UPASS_CI.TB_AM_USERMAS (M_USER_ALIAS,M_USER_ID) values ('witcher',164);
2184 2184
Insert into M2U_UPASS_CI.TB_AM_USERMAS (M_USER_ALIAS,M_USER_ID) values ('WKWK01',1346);
2185 2185
Insert into M2U_UPASS_CI.TB_AM_USERMAS (M_USER_ALIAS,M_USER_ID) values ('wohohoho',1225);
2186
Insert into M2U_UPASS_CI.TB_AM_USERMAS (M_USER_ALIAS,M_USER_ID) values ('wolverine',642);
2186
Insert into M2U_UPASS_CI.TB_AM_USERMAS (M_USER_ALIAS,M_USER_ID) values ('wolverinexx',642);
2187 2187
Insert into M2U_UPASS_CI.TB_AM_USERMAS (M_USER_ALIAS,M_USER_ID) values ('xchecker',1178);
2188 2188
Insert into M2U_UPASS_CI.TB_AM_USERMAS (M_USER_ALIAS,M_USER_ID) values ('xmaker',1177);
2189 2189
Insert into M2U_UPASS_CI.TB_AM_USERMAS (M_USER_ALIAS,M_USER_ID) values ('yasmin',718);

Also available in: Unified diff