{"id":3981,"date":"2018-07-01T12:56:30","date_gmt":"2018-07-01T03:56:30","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=3981"},"modified":"2018-07-01T12:58:27","modified_gmt":"2018-07-01T03:58:27","slug":"%eb%a7%88%ec%8a%a4%ed%82%b9-on-oracle-12c","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=3981","title":{"rendered":"\ub9c8\uc2a4\ud0b9 on Oracle 12c"},"content":{"rendered":"<h2>Data Redaction (\ub9c8\uc2a4\ud0b9)<\/h2>\n<p>Data Redaction\uc744 \uc0ac\uc6a9\ud558\uae30 \uc704\ud574\uc11c\ub294 \uba3c\uc800 \uad00\ub828 \ud328\ud0a4\uc9c0\uc5d0 \ub300\ud55c \uc2e4\ud589 \uad8c\ud55c\uc774 \ubd80\uc5ec\ub418\uc5b4\uc57c \ud569\ub2c8\ub2e4. \uadf8\ub9ac\uace0 \ud14c\uc2a4\ud2b8\ub97c \uc704\ud574 scott \uc720\uc800 \uc0c1\ud0dc\ub97c &#8220;unlock&#8221;\uc73c\ub85c \ubcc0\uacbd\ud558\uace0 redac.customers \ud14c\uc774\ube14\uc5d0 \ub300\ud55c \uc870\ud68c \uad8c\ud55c\uc744 scott \uc720\uc800\uc5d0\uac8c \ubd80\uc5ec\ud569\ub2c8\ub2e4.<\/p>\n<div>\n<table style=\"border-collapse: collapse;\" border=\"0\">\n<colgroup>\n<col style=\"width: 839px;\" \/><\/colgroup>\n<tbody valign=\"top\">\n<tr style=\"height: 19px;\">\n<td style=\"padding-top: 1px; padding-left: 1px; padding-right: 1px; border: solid 0.5pt;\" valign=\"bottom\"><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\">[oracle@New-Features-12c ~]$ <span style=\"background-color: #d9d9d9;\">sqlplus sys\/oracle_4U@pdb1 as sysdba<\/span><br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\">SQL*Plus: Release 12.1.0.2.0 Production on Fri Aug 28 12:40:04 2015<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\">Copyright (c) 1982, 2014, Oracle. All rights reserved.<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\">Connected to:<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\">Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 &#8211; 64bit Production<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\">With the Partitioning, Oracle Label Security, OLAP, Advanced Analytics<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\">and Real Application Testing options<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\">SQL&gt; <span style=\"background-color: #d9d9d9;\">grant execute on dbms_redact to redac;<\/span><br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\">Grant succeeded.<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\">SQL&gt; <span style=\"background-color: #d9d9d9;\">alter user scott identified by tiger account unlock;<\/span><br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\">User altered.<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\">SQL&gt; <span style=\"background-color: #d9d9d9;\">grant select on redac.customers to scott;<br \/>\n<\/span><\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\">Grant succeeded.<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p>\uba3c\uc800 Redaction \uc124\uc815\uc774 \ub418\uc9c0 \uc54a\uc740 \uc0c1\ud0dc\uc5d0\uc11c scott \uc720\uc800\ub85c CUSTOMERS \ud14c\uc774\ube14\uc744 \uc870\ud68c\ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4. \ud45c\uc2dc \uc81c\ud55c \uc5c6\uc774 \ubaa8\ub4e0 \uc815\ubcf4\uac00 \uadf8\ub300\ub85c \ucd9c\ub825\ub418\uace0 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<div>\n<table style=\"border-collapse: collapse;\" border=\"0\">\n<colgroup>\n<col style=\"width: 839px;\" \/><\/colgroup>\n<tbody valign=\"top\">\n<tr style=\"height: 19px;\">\n<td style=\"padding-top: 1px; padding-left: 1px; padding-right: 1px; border: solid 0.5pt;\" valign=\"bottom\"><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\">SQL&gt; <span style=\"background-color: #d9d9d9;\">connect scott\/tiger@pdb1<br \/>\n<\/span><\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\">Connected.<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\">SQL&gt; <span style=\"background-color: #d9d9d9;\">set line 120<\/span><br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\">SQL&gt; <span style=\"background-color: #d9d9d9;\">col customer_id for 9999<br \/>\n<\/span><\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\">SQL&gt; <span style=\"background-color: #d9d9d9;\">col customer_name for a15<\/span><br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\">SQL&gt; <span style=\"background-color: #d9d9d9;\">col credit_card_id for a20<br \/>\n<\/span><\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\">SQL&gt; <span style=\"background-color: #d9d9d9;\">col security_id for a15<br \/>\n<\/span><\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\">SQL&gt; <span style=\"background-color: #d9d9d9;\">col birth_year for 99<br \/>\n<\/span><\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\">SQL&gt; <span style=\"background-color: #d9d9d9;\">col birth_month for 99<\/span><br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\">SQL&gt; <span style=\"background-color: #d9d9d9;\">col birth_day for 99<br \/>\n<\/span><\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\">SQL&gt; <span style=\"background-color: #d9d9d9;\">select customer_id, customer_name, birth_year, birth_month, birth_day, credit_card_id, security_id from redac.customers where customer_id &lt; 10;<\/span><br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\">CUSTOMER_ID CUSTOMER_NAME BI BI BI CREDIT_CARD_ID SECURITY_ID<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\">&#8212;&#8212;&#8212;&#8211; &#8212;&#8212;&#8212;&#8212;&#8212; &#8212; &#8212; &#8212; &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211; &#8212;&#8212;&#8212;&#8212;&#8212;<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\"> 2 KimJiSeok 77 03 05 2090-9220-9931-7156 770305-4172246<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\"> 3 ShimMunWan 47 08 23 5400-1269-5566-6856 470823-4434278<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\"> 4 KwonJinKon 52 02 14 3477-4924-8034-3893 520214-4331755<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\"> 5 KangMyungDo 56 10 10 2090-9277-5065-6140 561010-3376442<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\"> 6 ParkSunDo 46 04 23 2400-6864-7017-4783 460423-1759576<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\"> 7 ChunKiKoo 66 08 24 9800-8074-6037-8236 660824-4696266<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\"> 8 ParkYoungKoo 41 06 13 9800-9913-9122-6702 410613-2369729<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\"> 9 NaYunSoo 46 02 29 1200-4269-2393-7732 460229-3127247<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\">8 rows selected.<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p>REDAC \uc720\uc800\ub85c \uc811\uc18d\ud558\uc5ec CUSTOMERS \ud14c\uc774\ube14\uc758<\/p>\n<p>security_id \uce7c\ub7fc \ub370\uc774\ud130\uc5d0 \ub300\ud574<\/p>\n<p>7\ubc88\uc9f8\ubd80\ud130 13\ubc88\uc9f8\uae4c\uc9c0 \uac12\uc740 * \ud45c\uc2dc\ub85c<\/p>\n<p>REDAC \uc720\uc800\uac00 \uc544\ub2cc \uc720\uc800\uc5d0 \ub300\ud574\uc11c<\/p>\n<p>\ubd80\ubd84\uc801\uc778 Redaction\uc744 \uc801\uc6a9\ud558\ub3c4\ub85d<\/p>\n<p>Redaction Policy\ub97c DBMS_REDACT \ud328\ud0a4\uc9c0\ub97c \uc774\uc6a9\ud574\uc11c \uc0dd\uc131\ud569\ub2c8\ub2e4.<\/p>\n<div>\n<table style=\"border-collapse: collapse;\" border=\"0\">\n<colgroup>\n<col style=\"width: 839px;\" \/><\/colgroup>\n<tbody valign=\"top\">\n<tr style=\"height: 19px;\">\n<td style=\"padding-top: 1px; padding-left: 1px; padding-right: 1px; border: solid 0.5pt;\" valign=\"bottom\"><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\">SQL&gt; <span style=\"background-color: #d9d9d9;\">connect redac\/redac@pdb1<br \/>\n<\/span><\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\">Connected.<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\">SQL&gt; <span style=\"background-color: #d9d9d9;\">BEGIN<br \/>\n<\/span><\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt; background-color: #d9d9d9;\"> DBMS_REDACT.ADD_POLICY(<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt; background-color: #d9d9d9;\"> object_schema =&gt; &#8216;redac&#8217;,<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt; background-color: #d9d9d9;\"> object_name =&gt; &#8216;customers&#8217;,<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt; background-color: #d9d9d9;\"> column_name =&gt; &#8216;security_id&#8217;,<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt; background-color: #d9d9d9;\"> policy_name =&gt; &#8216;redact_cust_private_info&#8217;,<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt; background-color: #d9d9d9;\"> function_type =&gt; DBMS_REDACT.PARTIAL,<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt; background-color: #d9d9d9;\"> function_parameters =&gt; &#8216;VVVVVVFVVVVVVV,VVVVVV-VVVVVVV,*,7,13&#8217;,<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt; background-color: #d9d9d9;\"> expression =&gt; &#8216;SYS_CONTEXT(&#8221;USERENV&#8221;,&#8221;SESSION_USER&#8221;) != &#8221;REDAC&#8221;&#8217;,<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt; background-color: #d9d9d9;\"> policy_description =&gt; &#8216;Partially redacts Security numbers&#8217;,<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt; background-color: #d9d9d9;\"> column_description =&gt; &#8216;ssn contains character Social Security numbers&#8217;);<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt; background-color: #d9d9d9;\"> END;<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt; background-color: #d9d9d9;\"> \/<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\">PL\/SQL procedure successfully completed.<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p>\uc774\uc81c SCOTT \uc720\uc800\ub85c \uc811\uc18d\ud558\uc5ec CUSTOMERS \ud14c\uc774\ube14\uc758 security_id \uce7c\ub7fc\uc758 \uac12\ub4e4\uc774 \uc5b4\ub5bb\uac8c \ucd9c\ub825\ub418\ub294 \uc9c0 \ud655\uc778\ud569\ub2c8\ub2e4.<\/p>\n<div>\n<table style=\"border-collapse: collapse;\" border=\"0\">\n<colgroup>\n<col style=\"width: 839px;\" \/><\/colgroup>\n<tbody valign=\"top\">\n<tr style=\"height: 19px;\">\n<td style=\"padding-top: 1px; padding-left: 1px; padding-right: 1px; border: solid 0.5pt;\" valign=\"bottom\"><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\">SQL&gt; <span style=\"background-color: #d9d9d9;\">connect scott\/tiger@pdb1;<br \/>\n<\/span><\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\">Connected.<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\">SQL&gt; <span style=\"background-color: #d9d9d9;\">select customer_id, customer_name, birth_year, birth_month, birth_day, credit_card_id, security_id from redac.customers where customer_id &lt; 10;<\/span><br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\">CUSTOMER_ID CUSTOMER_NAME BI BI BI CREDIT_CARD_ID SECURITY_ID<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\">&#8212;&#8212;&#8212;&#8211; &#8212;&#8212;&#8212;&#8212;&#8212; &#8212; &#8212; &#8212; &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211; &#8212;&#8212;&#8212;&#8212;&#8212;<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\"> 2 KimJiSeok 77 03 05 2090-9220-9931-7156 770305-*******<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\"> 3 ShimMunWan 47 08 23 5400-1269-5566-6856 470823-*******<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\"> 4 KwonJinKon 52 02 14 3477-4924-8034-3893 520214-*******<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\"> 5 KangMyungDo 56 10 10 2090-9277-5065-6140 561010-*******<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\"> 6 ParkSunDo 46 04 23 2400-6864-7017-4783 460423-*******<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\"> 7 ChunKiKoo 66 08 24 9800-8074-6037-8236 660824-*******<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\"> 8 ParkYoungKoo 41 06 13 9800-9913-9122-6702 410613-*******<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\"> 9 NaYunSoo 46 02 29 1200-4269-2393-7732 460229-*******<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\">8 rows selected.<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p>REDAC \uc720\uc800\ub85c \uc811\uc18d\ud588\uc744 \ub54c\ub294 Redaction \uc5c6\uc774 \ubaa8\ub4e0 \uc815\ubcf4\uac00 \ucd9c\ub825\ub418\ub294 \uac83\uc744 \uc54c \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<div>\n<table style=\"border-collapse: collapse;\" border=\"0\">\n<colgroup>\n<col style=\"width: 839px;\" \/><\/colgroup>\n<tbody valign=\"top\">\n<tr style=\"height: 19px;\">\n<td style=\"padding-top: 1px; padding-left: 1px; padding-right: 1px; border: solid 0.5pt;\" valign=\"bottom\"><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\">SQL&gt; <span style=\"background-color: #d9d9d9;\">connect redac\/redac@pdb1<\/span><br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\">Connected.<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\">SQL&gt; <span style=\"background-color: #d9d9d9;\">select customer_id, customer_name, birth_year, birth_month, birth_day, credit_card_id, security_id from redac.customers where customer_id &lt; 10;<\/span><br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\">CUSTOMER_ID CUSTOMER_NAME BI BI BI CREDIT_CARD_ID SECURITY_ID<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\">&#8212;&#8212;&#8212;&#8211; &#8212;&#8212;&#8212;&#8212;&#8212; &#8212; &#8212; &#8212; &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211; &#8212;&#8212;&#8212;&#8212;&#8212;<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\"> 2 KimJiSeok 77 03 05 2090-9220-9931-7156 770305-4172246<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\"> 3 ShimMunWan 47 08 23 5400-1269-5566-6856 470823-4434278<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\"> 4 KwonJinKon 52 02 14 3477-4924-8034-3893 520214-4331755<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\"> 5 KangMyungDo 56 10 10 2090-9277-5065-6140 561010-3376442<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\"> 6 ParkSunDo 46 04 23 2400-6864-7017-4783 460423-1759576<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\"> 7 ChunKiKoo 66 08 24 9800-8074-6037-8236 660824-4696266<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\"> 8 ParkYoungKoo 41 06 13 9800-9913-9122-6702 410613-2369729<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\"> 9 NaYunSoo 46 02 29 1200-4269-2393-7732 460229-3127247<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\">8 rows selected.<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p>\uc774\ubc88\uc5d0\ub294 credit_card_id \uce7c\ub7fc\uc5d0 \ub300\ud574\uc11c\ub3c4 ALTER POLICY \ud504\ub85c\uc2dc\uc800\ub97c \uc774\uc6a9\ud558\uc5ec Redation Policy\ub97c \ubcc0\uacbd\ud558\uace0 \ud574\ub2f9 \uc815\ubcf4\uac00 \uc5b4\ub5bb\uac8c \ucd9c\ub825\ub418\ub294\uc9c0 \ud655\uc778\ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4. \uc774\uc81c\ub294 credit_card_id \uc5d0 \ub300\ud574\uc11c\ub3c4 \ubd80\ubd84\uc801\uc778 Redaction\uc774 \uc801\uc6a9\ub41c \uac83\uc744 \uc54c \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<div>\n<table style=\"border-collapse: collapse;\" border=\"0\">\n<colgroup>\n<col style=\"width: 839px;\" \/><\/colgroup>\n<tbody valign=\"top\">\n<tr style=\"height: 19px;\">\n<td style=\"padding-top: 1px; padding-left: 1px; padding-right: 1px; border: solid 0.5pt;\" valign=\"bottom\"><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\">SQL&gt; <span style=\"background-color: #d9d9d9;\">BEGIN<br \/>\n<\/span><\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt; background-color: #d9d9d9;\"> DBMS_REDACT.ALTER_POLICY(<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt; background-color: #d9d9d9;\"> object_schema =&gt; &#8216;redac&#8217;,<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt; background-color: #d9d9d9;\"> object_name =&gt; &#8216;customers&#8217;,<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt; background-color: #d9d9d9;\"> policy_name =&gt; &#8216;redact_cust_private_info&#8217;,<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt; background-color: #d9d9d9;\"> action =&gt; dbms_redact.add_column,<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt; background-color: #d9d9d9;\"> column_name =&gt; &#8216;CREDIT_CARD_ID&#8217;,<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt; background-color: #d9d9d9;\"> function_type =&gt; dbms_redact.partial,<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt; background-color: #d9d9d9;\"> function_parameters =&gt; &#8216;VVVVFVVVVFVVVVFVVVV,VVVV-VVVV-VVVV-VVVV,*,11,16&#8217;,<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt; background-color: #d9d9d9;\"> expression =&gt; &#8216;1=1&#8217;,<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt; background-color: #d9d9d9;\"> policy_description =&gt; &#8216;Partially redacts Card numbers&#8217;,<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt; background-color: #d9d9d9;\"> column_description =&gt; &#8216;card contains character Card numbers&#8217;);<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt; background-color: #d9d9d9;\"> END;<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\"><span style=\"background-color: #d9d9d9;\"> \/<\/span><br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\">PL\/SQL procedure successfully completed.<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\">SQL&gt; <span style=\"background-color: #d9d9d9;\">select customer_id, customer_name, birth_year, birth_month, birth_day, credit_card_id, security_id from redac.customers where customer_id &lt; 10;<br \/>\n<\/span><\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\">CUSTOMER_ID CUSTOMER_NAME BI BI BI CREDIT_CARD_ID SECURITY_ID<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\">&#8212;&#8212;&#8212;&#8211; &#8212;&#8212;&#8212;&#8212;&#8212; &#8212; &#8212; &#8212; &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211; &#8212;&#8212;&#8212;&#8212;&#8212;<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\"> 2 KimJiSeok 77 03 05 2090-9220-99**-**** 770305-*******<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\"> 3 ShimMunWan 47 08 23 5400-1269-55**-**** 470823-*******<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\"> 4 KwonJinKon 52 02 14 3477-4924-80**-**** 520214-*******<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\"> 5 KangMyungDo 56 10 10 2090-9277-50**-**** 561010-*******<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\"> 6 ParkSunDo 46 04 23 2400-6864-70**-**** 460423-*******<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\"> 7 ChunKiKoo 66 08 24 9800-8074-60**-**** 660824-*******<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\"> 8 ParkYoungKoo 41 06 13 9800-9913-91**-**** 410613-*******<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\"> 9 NaYunSoo 46 02 29 1200-4269-23**-**** 460229-*******<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\">8 rows selected.<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p>\uc0dd\uc131\ud55c Redaction Policy\ub294 disable \uc2dc\ud0ac \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4. REDAC \uc720\uc800\ub85c DISABLE_POLICY \ud504\ub85c\uc2dc\uc800\ub85c \uc55e\uc11c \uc0dd\uc131\ud55c Policy\ub97c disable \uc2dc\ud0b5\ub2c8\ub2e4. \uad00\ub828 \ub515\uc154\ub108\ub9ac \ubdf0 REDACTION_POLICIES \uc5d0\uc11c\ub3c4 \uc774\ub97c \ud655\uc778\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<div>\n<table style=\"border-collapse: collapse;\" border=\"0\">\n<colgroup>\n<col style=\"width: 839px;\" \/><\/colgroup>\n<tbody valign=\"top\">\n<tr style=\"height: 19px;\">\n<td style=\"padding-top: 1px; padding-left: 1px; padding-right: 1px; border: solid 0.5pt;\" valign=\"bottom\"><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\">SQL&gt; <span style=\"background-color: #d9d9d9;\">connect redac\/redac@pdb1<br \/>\n<\/span><\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\">Connected.<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\">SQL&gt; BEGIN<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\"> DBMS_REDACT.DISABLE_POLICY (<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\"> object_schema =&gt; &#8216;redac&#8217;,<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\"> object_name =&gt; &#8216;customers&#8217;,<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\"> policy_name =&gt; &#8216;redact_cust_private_info&#8217;);<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\">END;<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\">\/<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\">PL\/SQL procedure successfully completed.<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\">SQL&gt; <span style=\"background-color: #d9d9d9;\">col object_name for a20<\/span><br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\">SQL&gt; <span style=\"background-color: #d9d9d9;\">col policy_name for a30<\/span><br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\">SQL&gt; <span style=\"background-color: #d9d9d9;\">select object_name,policy_name,enable from redaction_policies;<\/span><br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\">OBJECT_NAME POLICY_NAME ENABLE<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\">&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211; &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212; &#8212;&#8212;-<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\">CUSTOMERS redact_cust_private_info <span style=\"background-color: yellow;\">NO<\/span><\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p>SCOTT \uc720\uc800\ub85c \uc811\uc18d\ud574\uc11c CUSTOMERS \ud14c\uc774\ube14\uc744 \uc870\ud68c\ud558\uba74 Redaction\uc774 \ud574\uc81c\ub41c \uc54c \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<div>\n<table style=\"border-collapse: collapse;\" border=\"0\">\n<colgroup>\n<col style=\"width: 839px;\" \/><\/colgroup>\n<tbody valign=\"top\">\n<tr style=\"height: 19px;\">\n<td style=\"padding-top: 1px; padding-left: 1px; padding-right: 1px; border: solid 0.5pt;\" valign=\"bottom\"><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\">SQL&gt; <span style=\"background-color: #d9d9d9;\">connect scott\/tiger@pdb1<\/span><br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\">Connected.<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\">SQL&gt; <span style=\"background-color: #d9d9d9;\">select customer_id, customer_name, birth_year, birth_month, birth_day, credit_card_id, security_id from redac.customers where customer_id &lt; 10;<\/span><br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\">CUSTOMER_ID CUSTOMER_NAME BI BI BI CREDIT_CARD_ID SECURITY_ID<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\">&#8212;&#8212;&#8212;&#8211; &#8212;&#8212;&#8212;&#8212;&#8212; &#8212; &#8212; &#8212; &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211; &#8212;&#8212;&#8212;&#8212;&#8212;<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\"> 2 KimJiSeok 77 03 05 2090-9220-9931-7156 770305-4172246<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\"> 3 ShimMunWan 47 08 23 5400-1269-5566-6856 470823-4434278<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\"> 4 KwonJinKon 52 02 14 3477-4924-8034-3893 520214-4331755<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\"> 5 KangMyungDo 56 10 10 2090-9277-5065-6140 561010-3376442<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\"> 6 ParkSunDo 46 04 23 2400-6864-7017-4783 460423-1759576<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\"> 7 ChunKiKoo 66 08 24 9800-8074-6037-8236 660824-4696266<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\"> 8 ParkYoungKoo 41 06 13 9800-9913-9122-6702 410613-2369729<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\"> 9 NaYunSoo 46 02 29 1200-4269-2393-7732 460229-3127247<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\">8 rows selected.<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p>DROP_POLICY \ud504\ub85c\uc2dc\uc800\ub85c \uc0dd\uc131\ud55c Redation Policy\ub97c \uc0ad\uc81c\ud560 \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<div>\n<table style=\"border-collapse: collapse;\" border=\"0\">\n<colgroup>\n<col style=\"width: 839px;\" \/><\/colgroup>\n<tbody valign=\"top\">\n<tr style=\"height: 19px;\">\n<td style=\"padding-top: 1px; padding-left: 1px; padding-right: 1px; border: solid 0.5pt;\" valign=\"bottom\"><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\">SQL&gt; <span style=\"background-color: #d9d9d9;\">BEGIN<br \/>\n<\/span><\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt; background-color: #d9d9d9;\"> DBMS_REDACT.DROP_POLICY (<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt; background-color: #d9d9d9;\"> object_schema =&gt; &#8216;redac&#8217;,<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt; background-color: #d9d9d9;\"> object_name =&gt; &#8216;customers&#8217;,<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt; background-color: #d9d9d9;\"> policy_name =&gt; &#8216;redact_cust_private_info&#8217;);<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt; background-color: #d9d9d9;\">END;<br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\"><span style=\"background-color: #d9d9d9;\">\/<\/span><br \/>\n<\/span><\/p>\n<p><span style=\"color: #262626; font-family: Courier New; font-size: 9pt;\">PL\/SQL procedure successfully completed.<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Data Redaction (\ub9c8\uc2a4\ud0b9) Data Redaction\uc744 \uc0ac\uc6a9\ud558\uae30 \uc704\ud574\uc11c\ub294 \uba3c\uc800 \uad00\ub828 \ud328\ud0a4\uc9c0\uc5d0 \ub300\ud55c \uc2e4\ud589 \uad8c\ud55c\uc774 \ubd80\uc5ec\ub418\uc5b4\uc57c \ud569\ub2c8\ub2e4. \uadf8\ub9ac\uace0 \ud14c\uc2a4\ud2b8\ub97c \uc704\ud574 scott \uc720\uc800 \uc0c1\ud0dc\ub97c &#8220;unlock&#8221;\uc73c\ub85c \ubcc0\uacbd\ud558\uace0 redac.customers \ud14c\uc774\ube14\uc5d0 \ub300\ud55c \uc870\ud68c \uad8c\ud55c\uc744 scott \uc720\uc800\uc5d0\uac8c \ubd80\uc5ec\ud569\ub2c8\ub2e4. [oracle@New-Features-12c ~]$ sqlplus sys\/oracle_4U@pdb1 as sysdba SQL*Plus: Release 12.1.0.2.0 Production on Fri Aug 28 12:40:04 2015 Copyright (c) 1982, 2014, Oracle. All rights reserved. [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":2427,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"spay_email":""},"categories":[20,336],"tags":[16,762,1101,763],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/2018\/01\/data-encryption-facts.jpg?fit=468%2C327","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/3981"}],"collection":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3981"}],"version-history":[{"count":2,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/3981\/revisions"}],"predecessor-version":[{"id":3983,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/3981\/revisions\/3983"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/2427"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3981"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3981"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3981"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}