{"id":8147,"date":"2019-04-12T09:55:28","date_gmt":"2019-04-12T09:55:28","guid":{"rendered":"https:\/\/ittutorial.org\/?p=8147"},"modified":"2019-07-04T13:12:44","modified_gmt":"2019-07-04T13:12:44","slug":"oracle-transparent-data-encryptiontde-1","status":"publish","type":"post","link":"https:\/\/ittutorial.org\/oracle-transparent-data-encryptiontde-1\/","title":{"rendered":"Oracle Transparent Data Encryption(TDE)-1"},"content":{"rendered":"<p>Merhaba, bu yaz\u0131 serimde Oracle&#8217;\u0131n g\u00fcvenlik \u00e7\u00f6z\u00fcmlerinden biri olan Transparent Data Encryption konusunu ele ald\u0131m.<\/p>\n<h5>TDE Nedir :<\/h5>\n<p>Normalde Oracle veritaban\u0131nda datafile&#8217;lar\u0131m\u0131z okunabilir olarak bulunur, veritaban\u0131m\u0131za herhangi bir sald\u0131r\u0131 olursa datafile&#8217;lar\u0131m\u0131z korunmas\u0131z olarak kalm\u0131\u015f olur ve sald\u0131rganlar b\u00fct\u00fcn bilgilerimizi okuyabilir. \u00c7\u00f6z\u00fcm olarak TDE veri dosyalar\u0131m\u0131z\u0131 \u015fifreler ve herhangi <strong>select <\/strong>sorgular\u0131nda \u015fifreler \u00e7\u00f6z\u00fclm\u00fc\u015f halde g\u00f6sterilmesini sa\u011flar(Bunun oracle kendisi sa\u011flar \u015fifre \u00e7\u00f6zmek i\u00e7in herhangi bir\u015fey yapmam\u0131z gerekmez.)<\/p>\n<ul>\n<li>Datafiler&#8217;lar\u0131m\u0131z \u015fifrelendi\u011fi i\u00e7in al\u0131nan yedeklerimiz de \u015fifrelenmektedir.<\/li>\n<li>TDE \u00e7\u00f6z\u00fcm\u00fc sayesinde veriyi \u015fifrelemek i\u00e7in farkl\u0131 program veya prosed\u00fcr yazmaya gerek kalmaz.<\/li>\n<\/ul>\n<h5>TDE ile iki \u00e7e\u015fit \u015fifreleme yapabiliriz:<\/h5>\n<p>1. Kolon \u015eifreleme<\/p>\n<p>2. Tablespace \u015eifreleme<\/p>\n<p>Her iki y\u00f6ntemi de ger\u00e7ekle\u015ftirmek i\u00e7in veritaban\u0131 d\u0131\u015f\u0131nda bir master anahtar olu\u015fturulur bu master anahtar ile \u015fifrelemede kulan\u0131lacak olan ikincil anahtar(veritaban\u0131 i\u00e7inde) \u015fifrelenir.<\/p>\n<p>\u015eifreleme i\u00e7in farkl\u0131 algoritmalar kullan\u0131labilir, bunlar;<\/p>\n<ul>\n<li>168 bitlik DES Algoritmas\u0131<\/li>\n<li>128 bitlik AES Algoritmas\u0131<\/li>\n<li>192 bitlik AES Algoritmas\u0131<\/li>\n<li>256 bitlik AES Algoritmas\u0131<\/li>\n<\/ul>\n<p>Kolon veya tablespace baz\u0131nda ihtiyac\u0131m\u0131za uygun algoritmay\u0131 kullanarak verileri \u015fifreleyebiliriz. Bir sonraki yaz\u0131da Master anahtar olu\u015fturma ile devam edece\u011fiz, \u015fimdilik g\u00f6r\u00fc\u015fmek \u00fczere.<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Merhaba, bu yaz\u0131 serimde Oracle&#8217;\u0131n g\u00fcvenlik \u00e7\u00f6z\u00fcmlerinden biri olan Transparent Data Encryption konusunu ele ald\u0131m. TDE Nedir : Normalde Oracle veritaban\u0131nda datafile&#8217;lar\u0131m\u0131z okunabilir olarak bulunur, veritaban\u0131m\u0131za herhangi bir sald\u0131r\u0131 olursa datafile&#8217;lar\u0131m\u0131z korunmas\u0131z olarak kalm\u0131\u015f olur ve sald\u0131rganlar b\u00fct\u00fcn bilgilerimizi okuyabilir. \u00c7\u00f6z\u00fcm olarak TDE veri dosyalar\u0131m\u0131z\u0131 \u015fifreler ve herhangi select sorgular\u0131nda \u015fifreler \u00e7\u00f6z\u00fclm\u00fc\u015f halde g\u00f6sterilmesini sa\u011flar(Bunun &hellip;<\/p>\n","protected":false},"author":67,"featured_media":8275,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[5282,14],"tags":[3412,3417,3414,3415,3409,3407,3416,3410,3406,3421,3422,3420,3411,3419,1353,3404,3413,3424,1770,3423,3405,3426,3425,3408,3418],"class_list":["post-8147","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-oracle-guvenlik","category-oracle-turkce","tag-column-security","tag-database-security","tag-how-to-encrypt-column","tag-how-to-encrypt-tablespace","tag-kolon-sifreleme","tag-oracle-da-guvenlik-cozumleri","tag-oracle-guvenligi","tag-oracle-kolon-sifreleme","tag-oracle-security","tag-oracle-security-advantage","tag-oracle-security-solution","tag-oracle-table-security","tag-oracle-tablespace-sifreleme","tag-oracle-tablo-nasil-sifrelenir","tag-oracle-transparent-data-encryption","tag-oralce-tde","tag-tablespace-security","tag-tde-solution","tag-transparent-data-encryption","tag-transparent-data-encryption-column","tag-transparent-data-encryption-nasil-kullanilir","tag-transparent-data-encryption-on-column","tag-transparent-data-encryption-on-tablespace","tag-veritabani-guvenligi","tag-veritabani-sifreleme"],"aioseo_notices":[],"jetpack_featured_media_url":"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/04\/oracle-security-presentation-16-638.jpg","jetpack_sharing_enabled":true,"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/8147","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/users\/67"}],"replies":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/comments?post=8147"}],"version-history":[{"count":1,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/8147\/revisions"}],"predecessor-version":[{"id":8148,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/8147\/revisions\/8148"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/media\/8275"}],"wp:attachment":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/media?parent=8147"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/categories?post=8147"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/tags?post=8147"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}