m2u-upass-admin / DBScript / insert_tb_am_user.sql @ 85:b21ea78dfbb4
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; |