m2u-upass-admin / DBScript / insert_tb_am_user.sql @ 107:213339ef88c2
History | View | Annotate | Download (3.12 KB)
1 |
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;
|