Z-Archive » Maybank Projects » M2U UPASS Project

Rem =====================================================================

Rem   NAME

Rem     <insert_tb_am_tac.sql>

Rem   DESCRIPTION

Rem     <Insert Data into UPASS TAC Table> 

Rem   MODULE

Rem     <Authentication Module>

Rem   MODIFIED  (MM/DD/YYYY)

Rem        Danniell   03/12/2010 - Creation

Rem        xxxxxx           mm/dd/yyyy - Modify

Rem =====================================================================

SET DEFINE OFF;

Insert into TB_AM_TAC

   (T_USER_ID, T_TAC_CIPHERTEXT, T_TAC_STATE, T_DATE_GENERATED, T_DATE_FIRST_USED, 

    T_DATE_LAST_USED, T_USE_COUNT, T_ERROR_COUNT, T_SESSION_ID)

 Values

   (1, NULL, 0, SYSTIMESTAMP, NULL, 

    NULL, 0, 0, NULL);

Insert into TB_AM_TAC

   (T_USER_ID, T_TAC_CIPHERTEXT, T_TAC_STATE, T_DATE_GENERATED, T_DATE_FIRST_USED, 

    T_DATE_LAST_USED, T_USE_COUNT, T_ERROR_COUNT, T_SESSION_ID)

 Values

   (2, NULL, 0, SYSTIMESTAMP, NULL, 

    NULL, 0, 0, NULL);

Insert into TB_AM_TAC

   (T_USER_ID, T_TAC_CIPHERTEXT, T_TAC_STATE, T_DATE_GENERATED, T_DATE_FIRST_USED, 

    T_DATE_LAST_USED, T_USE_COUNT, T_ERROR_COUNT, T_SESSION_ID)

 Values

   (3, NULL, 0, SYSTIMESTAMP, NULL, 

    NULL, 0, 0, NULL);

Insert into TB_AM_TAC

   (T_USER_ID, T_TAC_CIPHERTEXT, T_TAC_STATE, T_DATE_GENERATED, T_DATE_FIRST_USED, 

    T_DATE_LAST_USED, T_USE_COUNT, T_ERROR_COUNT, T_SESSION_ID)

 Values

   (4, NULL, 0, SYSTIMESTAMP, NULL, 

    NULL, 0, 0, NULL);

COMMIT;