Revision 58:077576134e91 test/resources/db-scripts/m2u-upass-ci-oracle.sql
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