m2u-upass-admin / DBScript / insert_tb_am_user.sql @ 136:0ec4b0eea084
History | View | Annotate | Download (3.12 KB)
| 1 | 0:ea666cc7880e | hadi | Rem ===================================================================== |
|---|---|---|---|
| 2 | Rem NAME |
||
| 3 | Rem <insert_tb_am_user.sql> |
||
| 4 | Rem DESCRIPTION |
||
| 5 | Rem <Insert Data into UPASS USER Table> |
||
| 6 | Rem MODULE |
||
| 7 | Rem <Authentication Module> |
||
| 8 | Rem MODIFIED (MM/DD/YYYY) |
||
| 9 | Rem Danniell 03/12/2010 - Creation |
||
| 10 | Rem xxxxxx mm/dd/yyyy - Modify |
||
| 11 | Rem ===================================================================== |
||
| 12 | |||
| 13 | SET DEFINE OFF;
|
||
| 14 | Insert into TB_AM_USER |
||
| 15 | (U_USER_ID, U_USER_ALIAS, U_USER_TYPE, U_USER_DESC, U_DATE_CREATED, |
||
| 16 | U_DATE_LAST_USED, U_USE_COUNT, U_DATE_LAST_ACT, U_DATE_LAST_LOCK, U_USER_STATE, |
||
| 17 | U_DATE_LOCK_FROM, U_DATE_LOCK_TO, P_PASSWD_CIPHERTEXT, P_PASSWD_STATE, P_DATE_GENERATED, |
||
| 18 | P_DATE_FIRST_USED, P_DATE_LAST_USED, P_USE_COUNT, P_ERROR_COUNT, P_EXPIRED_STATUS, |
||
| 19 | P_DATE_EXPIRED, P_PASSWD_HIST, U_ACCESS_NO, U_CUSTOMER_TYPE, U_CARD_NO, |
||
| 20 | U_VALIDATION) |
||
| 21 | Values
|
||
| 22 | (1, 'root', 0, 'Root ID', SYSTIMESTAMP, |
||
| 23 | NULL, 0, NULL, NULL, 0, |
||
| 24 | NULL, NULL, '33A485CB146E1153C69B588C671AB474F2E5B800', 0, SYSTIMESTAMP, |
||
| 25 | NULL, NULL, 0, 0, 1, |
||
| 26 | NULL, NULL, NULL, NULL, NULL, |
||
| 27 | NULL);
|
||
| 28 | Insert into TB_AM_USER |
||
| 29 | (U_USER_ID, U_USER_ALIAS, U_USER_TYPE, U_USER_DESC, U_DATE_CREATED, |
||
| 30 | U_DATE_LAST_USED, U_USE_COUNT, U_DATE_LAST_ACT, U_DATE_LAST_LOCK, U_USER_STATE, |
||
| 31 | U_DATE_LOCK_FROM, U_DATE_LOCK_TO, P_PASSWD_CIPHERTEXT, P_PASSWD_STATE, P_DATE_GENERATED, |
||
| 32 | P_DATE_FIRST_USED, P_DATE_LAST_USED, P_USE_COUNT, P_ERROR_COUNT, P_EXPIRED_STATUS, |
||
| 33 | P_DATE_EXPIRED, P_PASSWD_HIST, U_ACCESS_NO, U_CUSTOMER_TYPE, U_CARD_NO, |
||
| 34 | U_VALIDATION) |
||
| 35 | Values
|
||
| 36 | (2, 'TokenOwner', 1, 'TokenOwner', SYSTIMESTAMP, |
||
| 37 | NULL, 0, NULL, NULL, 0, |
||
| 38 | NULL, NULL, '9400A88AD1B95D467A1E13388C2D46399B8E7826', 0, SYSTIMESTAMP, |
||
| 39 | NULL, NULL, 0, 0, 1, |
||
| 40 | NULL, NULL, NULL, NULL, NULL, |
||
| 41 | NULL);
|
||
| 42 | Insert into TB_AM_USER |
||
| 43 | (U_USER_ID, U_USER_ALIAS, U_USER_TYPE, U_USER_DESC, U_DATE_CREATED, |
||
| 44 | U_DATE_LAST_USED, U_USE_COUNT, U_DATE_LAST_ACT, U_DATE_LAST_LOCK, U_USER_STATE, |
||
| 45 | U_DATE_LOCK_FROM, U_DATE_LOCK_TO, P_PASSWD_CIPHERTEXT, P_PASSWD_STATE, P_DATE_GENERATED, |
||
| 46 | P_DATE_FIRST_USED, P_DATE_LAST_USED, P_USE_COUNT, P_ERROR_COUNT, P_EXPIRED_STATUS, |
||
| 47 | P_DATE_EXPIRED, P_PASSWD_HIST, U_ACCESS_NO, U_CUSTOMER_TYPE, U_CARD_NO, |
||
| 48 | U_VALIDATION) |
||
| 49 | Values
|
||
| 50 | (3, 'UpassAdmin', 1, 'UPass System ID', SYSTIMESTAMP, |
||
| 51 | NULL, 0, NULL, NULL, 0, |
||
| 52 | NULL, NULL, 'A482FAFF5C1D23933BB0AC65634CAA4F7BE26CCE', 0, SYSTIMESTAMP, |
||
| 53 | NULL, NULL, 0, 0, 1, |
||
| 54 | NULL, NULL, NULL, NULL, NULL, |
||
| 55 | NULL);
|
||
| 56 | Insert into TB_AM_USER |
||
| 57 | (U_USER_ID, U_USER_ALIAS, U_USER_TYPE, U_USER_DESC, U_DATE_CREATED, |
||
| 58 | U_DATE_LAST_USED, U_USE_COUNT, U_DATE_LAST_ACT, U_DATE_LAST_LOCK, U_USER_STATE, |
||
| 59 | U_DATE_LOCK_FROM, U_DATE_LOCK_TO, P_PASSWD_CIPHERTEXT, P_PASSWD_STATE, P_DATE_GENERATED, |
||
| 60 | P_DATE_FIRST_USED, P_DATE_LAST_USED, P_USE_COUNT, P_ERROR_COUNT, P_EXPIRED_STATUS, |
||
| 61 | P_DATE_EXPIRED, P_PASSWD_HIST, U_ACCESS_NO, U_CUSTOMER_TYPE, U_CARD_NO, |
||
| 62 | U_VALIDATION) |
||
| 63 | Values
|
||
| 64 | (4, 'mssadmin', 1, NULL, SYSTIMESTAMP, |
||
| 65 | NULL, 0, NULL, NULL, 0, |
||
| 66 | NULL, NULL, 'C5C8CD2F0F5F137C7D5055A5A3B7CDD7785157AF', 0, SYSTIMESTAMP, |
||
| 67 | NULL, NULL, 0, 0, 1, |
||
| 68 | NULL, NULL, NULL, '00', NULL, |
||
| 69 | NULL);
|
||
| 70 | COMMIT; |