{"id":451,"date":"2014-01-26T02:09:38","date_gmt":"2014-01-26T11:09:38","guid":{"rendered":"\/blog\/?p=451"},"modified":"2023-09-21T09:38:47","modified_gmt":"2023-09-21T00:38:47","slug":"datasecure-%ec%98%a4%eb%a5%98-%eb%b3%b5%ea%b5%ac-%ec%8b%9c%eb%82%98%eb%a6%ac%ec%98%a4-1","status":"publish","type":"post","link":"https:\/\/hasu0707.duckdns.org\/blog\/?p=451","title":{"rendered":"DataSecure \uc624\ub958 \ubcf5\uad6c \uc2dc\ub098\ub9ac\uc624 #1"},"content":{"rendered":"\n

\u25a0 \uc0c1\ud669<\/span>

1. \ubcf5\ud638\ud654 \uc548\ub428<\/span>
2. INGRIAN DB\uacc4\uc815 \uc774\uc0c1<\/span>


\u25a0 \ud574\uacb0\ubc29\ubc95<\/span>

1. [\ubc31\uc5c5] \ud544\uc694\ud55c \ud14c\uc774\ube14\uc744 \ubc31\uc5c5\ud55c\ub2e4. (\ubc31\uc5c5 \ubc29\ubc95 \ucc38\uc870)
<\/b><\/span><\/p>


<\/p>

2. [\uacc4\uc815 \uc0ad\uc81c] INGRIAN \uacc4\uc815 \uc0ad\uc81c \ud6c4 \uc7ac \uc0dd\uc131<\/b><\/span><\/p>


<\/span><\/p>

3. [\uc7ac \uc124\uce58] ProtectDB \uc7ac \uc124\uce58 (\uc124\uce58 \uc2dc INSTANCE ID\ub97c \uc774\uc804 \uac83\uc73c\ub85c \uc124\uc815\ud55c\ub2e4.<\/span>)<\/b><\/span><\/p>


<\/span><\/p>

4. [\ubcf5\uc6d0] \ubc31\uc5c5\ud588\ub358 \ud14c\uc774\ube14\uc744 \ubcf5\uc6d0 \ud55c\ub2e4.<\/b><\/span>

\uc608)<\/span>
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');<\/span>

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');<\/span>

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');<\/span><\/p>


<\/span><\/p>

<\/span>5. [\ubdf0\ud2b8\ub9ac\uac70 \uc815\ud569\uc131 \ubcf5\uad6c]

DataSecure \uc5d0 \uc811\uc18d\ud558\uc5ec<\/b><\/span>
Security \u2192 Databases \u2192 Database: DB\uba85 \u2192 Table: \ud14c\uc774\ube14\uba85<\/span> \uba54\ub274\uc5d0\uc11c<\/span>
\"Delete View and Triggers\" \ud6c4 \ub2e4\uc2dc \"Create View and Triggers\"\ub97c \uc2e4\ud589\ud55c\ub2e4.<\/span><\/b>
<\/p>\n","protected":false},"excerpt":{"rendered":"

\u25a0 \uc0c1\ud669 1. \ubcf5\ud638\ud654 \uc548\ub4282. INGRIAN DB\uacc4\uc815 \uc774\uc0c1 \u25a0 \ud574\uacb0\ubc29\ubc95 1. [\ubc31\uc5c5] \ud544\uc694\ud55c \ud14c\uc774\ube14\uc744 \ubc31\uc5c5\ud55c\ub2e4. (\ubc31\uc5c5 \ubc29\ubc95 \ucc38\uc870) 2. [\uacc4\uc815 \uc0ad\uc81c] INGRIAN \uacc4\uc815 \uc0ad\uc81c \ud6c4 \uc7ac \uc0dd\uc131 3. [\uc7ac \uc124\uce58] ProtectDB \uc7ac \uc124\uce58 (\uc124\uce58 \uc2dc INSTANCE ID\ub97c \uc774\uc804 \uac83\uc73c\ub85c \uc124\uc815\ud55c\ub2e4.) 4. [\ubcf5\uc6d0] \ubc31\uc5c5\ud588\ub358 \ud14c\uc774\ube14\uc744 \ubcf5\uc6d0 \ud55c\ub2e4. \uc608)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) […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[12],"tags":[],"class_list":["post-451","post","type-post","status-publish","format-standard","hentry","category-computing_security"],"_links":{"self":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/451","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=451"}],"version-history":[{"count":0,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/451\/revisions"}],"wp:attachment":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=451"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=451"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=451"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}