■ 상황
1. 복호화 안됨
2. INGRIAN DB계정 이상
■ 해결방법
1. [백업] 필요한 테이블을 백업한다. (백업 방법 참조)
2. [계정 삭제] INGRIAN 계정 삭제 후 재 생성
3. [재 설치] ProtectDB 재 설치 (설치 시 INSTANCE ID를 이전 것으로 설정한다.)
4. [복원] 백업했던 테이블을 복원 한다.
예)
Insert into INGRIAN.ING_ENCRYPTED_TABLE (ENCRPT_TBL_ID,DB_NM,TBL_OWNR_NM,ORGNL_TBL_NM,NEW_TBL_NM,ADD_ID_CLMN_FL,ID_CLMN_NM,ID_CLMN_DATA_TYPE_NM,ID_CLMN_LEN_QTY,ID_CLMN_PRCSN_QTY,ID_CLMN_SCALE_QTY,TMPRY_TBL_NM,TMPRY_TBL_TBLSPC_NM,INTRM_VW_NM,INSRT_TRG_NM,UPDT_TRG_NM,PRIMARY_KEY_COL_NMS,PRIMARY_KEY_NM,TMPRY_TBL_CREATE_FL,VW_CREATE_FL,SERVER_VERSION,SERVER_MIGRATION_VERSION,UDF_VERSION,SEQ_NM,OLD_DATA_EXIST_FL,CREATE_DT,CREATE_USER_NM,LAST_MDFY_DT,LAST_MDFY_USER_NM,META_CNTR,OP_ONLINE)
values
(1,'','TEST','TBL_TEST','TBL_TEST_NEW','Y','ING_ROW_ID','NUMBER',38,38,0,null,null,'TBL_TEST_IDV','TBL_TEST_INS_TRIG','TBL_TEST_UPD_TRIG',null,null,'N','Y','4.3.1','4.2.0','4.3.0','ING_SEQ_1','N',to_date('14/01/26','RR/MM/DD'),'TEST',to_date('14/01/26','RR/MM/DD'),'TEST',1,'N');
Insert into INGRIAN.ING_ENCRYPTED_COLUMN (ENCRPT_CLMN_ID,ENCRPT_TBL_ID,ORGNL_CLMN_NM,NEW_CLMN_NM,ENCRPT_KEY_NM,ENCRPT_ALGRTHM_NM,ENCRPT_MODE_NM,ENCRPT_PAD_NM,ENCRPT_IV_TYPE_CD,ENCRPT_IV_NM,ENCRPT_IV_CLMN_NM,ENCRPT_NULL_RPLCMNT_NM,ERR_RPLCMNT_ID,CLMN_ORGNL_DATA_TYPE_NM,CLMN_ORGNL_LEN_QTY,CLMN_ORGNL_PRCSN_QTY,CLMN_ORGNL_SCALE_QTY,CLMN_NULL_FL,CLMN_NEW_DATA_TYPE_NM,CLMN_NEW_LEN_QTY,CLMN_DATA_MGRT_FL,ENCRPT_FL,CREATE_DT,CREATE_USER_NM,LAST_MDFY_DT,LAST_MDFY_USER_NM,DMN_IDX_TBLSPC_NM,DMN_REG_IDX_NM,DMN_IDX_NM,DMN_IDX_CREATE_FL,DMN_IDX_FL,ROTATE_CLMN_NM,ROTATE_CLMN_CREATE_FL,ROTATE_KEY_NM,ROTATE_IV_NM,REROTATE_FL)
values
(1,1,'TEST_NAME','TEST_NAME_NEW','test_key','AES','CBC','PKCS5Padding','C','F52A367CDE9799157E1B3B58CBFD7AE4',null,null,null,'VARCHAR2',30,30,null,'Y','RAW',32,'Y','Y',to_date('14/01/26','RR/MM/DD'),'TEST',to_date('14/01/26','RR/MM/DD'),'TEST',null,null,null,'N','N',null,'N',null,null,'N');
Insert into INGRIAN.ING_AUTHORIZED_USER (ATHRZ_USER_ID,DB_USER_NM,ENCRPT_USER_NM,ENCRPT_ACCESS_CD,DGTL_SGNTR_NM,CREATE_DT,CREATE_USER_NM,LAST_MDFY_DT,LAST_MDFY_USER_NM)
values
(4,'TEST','jdlqI4v6RIEAZnIftHDQBA==','xzdttKqb0BvqKd38cjl26A==','6DKVbFS9FxH4MIKIbkHKfJx9jZvtRryVCmZuqrU6Nw6LBr6J4urOrWBkim8NXxy3RiRLNfTN96w=',to_date('14/01/26','RR/MM/DD'),'INGRIAN',to_date('14/01/26','RR/MM/DD'),'INGRIAN');
5. [뷰트리거 정합성 복구]
DataSecure 에 접속하여
Security → Databases → Database: DB명 → Table: 테이블명 메뉴에서
"Delete View and Triggers" 후 다시 "Create View and Triggers"를 실행한다.