{"id":18945,"date":"2021-10-11T14:05:10","date_gmt":"2021-10-11T11:05:10","guid":{"rendered":"http:\/\/dev.profelis.net\/?p=18945"},"modified":"2023-02-01T10:57:58","modified_gmt":"2023-02-01T07:57:58","slug":"postgresql-entegrasyonu-bolum-5","status":"publish","type":"post","link":"https:\/\/profelis.com.tr\/en\/2021\/10\/11\/postgresql-entegrasyonu-bolum-5\/","title":{"rendered":"PostgreSQL Entegrasyonu B\u00f6l\u00fcm 5: G\u00fcvenlik Entegrasyonu"},"content":{"rendered":"

PostgreSQL Entegrasyonu blog serisinin s\u0131radaki b\u00f6l\u00fcm\u00fcnde kurumlar\u0131n daha fazla ve h\u0131zl\u0131 \u00e7al\u0131\u015fmas\u0131na yard\u0131mc\u0131 olabilecek PostgreSQL entegrasyonunu ke\u015ffetmeye devam ediyoruz.<\/p>\n

Bu blog yaz\u0131s\u0131 bir sonraki \u00f6nemli alan olan g\u00fcvenlik entegrasyonuna odaklanacak.<\/p>\n

\"Integrating<\/p>\n

G\u00fcvenlik Entegrasyonu
\n<\/span><\/strong><\/h2>\n

PostgreSQL g\u00fcvenli\u011fi veri merkezi veya bulut ba\u011flam\u0131nda g\u00f6r\u00fclmelidir. \u0130ki durumda da, veritaban\u0131n\u0131n g\u00fcvenli\u011fi Derinlemesine Savunma (Defense in Depth – DiD) konseptinin bir par\u00e7as\u0131 olmal\u0131d\u0131r. Kubernetes \u00fczerinde Bulut Tabanl\u0131 PostgreSQL i\u00e7in 4C (Cloud, Cluster, Container, Code) modeli \u00f6nde gelen en iyi uygulamad\u0131r. Veri merkezlerindeki PostgreSQL da\u011f\u0131t\u0131mlar\u0131nda DiD en iyi uygulamalar\u0131 ise \u201cPostgreSQL \u0130\u00e7in En \u0130yi G\u00fcvenlik Uygulamalar\u0131<\/a>\u201d yaz\u0131s\u0131nda tart\u0131\u015f\u0131lmaktad\u0131r.<\/p>\n

PostgreSQL i\u00e7erisinde, Kimlik Do\u011frulama (Authentication), Yetkilendirme (Authorization), Denetim (Auditing) ve \u015eifreleme (Encryption) g\u00f6z \u00f6n\u00fcnde bulundurulmal\u0131d\u0131r.<\/p>\n

Kimlik do\u011frulama i\u00e7in, veritaban\u0131ndaki kullan\u0131c\u0131 ve parolalar\u0131 PostgreSQL tan\u0131mlayabilir. Bu durumda, daha az g\u00fcvenli MD5 metodunu b\u0131rakarak parolalar\u0131n g\u00fcvenli\u011fini sa\u011flamak i\u00e7in SCRAM kimlik do\u011frulamay\u0131 kullanman\u0131z\u0131 tavsiye ediyoruz. E\u011fer yerel olarak tan\u0131mlanm\u0131\u015f kullan\u0131c\u0131lar ve parolalar kullan\u0131yorsan\u0131z; son kullanma tarihi, karma\u015f\u0131kl\u0131k ve tekrar kullan\u0131m kurallar\u0131n\u0131 tan\u0131mlaman\u0131za izin veren EDB PostgreSQL parola profillerini kullanman\u0131z\u0131 tavsiye ediyoruz.<\/p>\n

Yetkilendirme PostgreSQL veritaban\u0131 i\u00e7erisinde; ayr\u0131cal\u0131klar tan\u0131mlan\u0131rken kullan\u0131lan LOGIN, SUPERUSER vb. \u00f6znitelikler ve roller (\u00f6rn. kullan\u0131c\u0131lar\u0131 ve gruplar\u0131 yeniden grupland\u0131rma terimi) kullan\u0131larak i\u015flenmektedir.<\/p>\n

Ayr\u0131 denetim g\u00fcnl\u00fc\u011f\u00fc tutulmas\u0131, finansal servisler gibi y\u00fcksek uyum gereklili\u011fine sahip ortamlarda \u00e7ok de\u011ferlidir. EDB\u2019nin Postgres Advanced Server\u2019i nesne t\u00fcr\u00fcne g\u00f6re DDL, DML veya SELECT i\u015flemleri i\u00e7in farkl\u0131 seviyelerde g\u00fcnl\u00fck kayd\u0131 i\u00e7eren ayr\u0131 bir denetim g\u00fcnl\u00fc\u011f\u00fc tutar.<\/p>\n

PostgreSQL i\u00e7in kimlik do\u011frulama, yetkilendirme ve denetim en iyi uygulamalar\u0131 bu blogda kapsaml\u0131 olarak tart\u0131\u015f\u0131lmaktad\u0131r.<\/p>\n

Kimlik do\u011frulama, yetkilendirme, denetim ve \u015fifreleme her zaman bir arada ele al\u0131nmal\u0131d\u0131r ve en az ayr\u0131cal\u0131k yakla\u015f\u0131m\u0131yla kullan\u0131lmal\u0131d\u0131r.<\/p>\n

Y\u00fcksek Eri\u015filebilirlik ve Felaket Kurtarma ara\u00e7lar\u0131n\u0131 konu edinen bir sonraki blog payla\u015f\u0131m\u0131 i\u00e7in takipte kal\u0131n. Bu s\u0131rada, PostgreSQL entegrasyonuna ili\u015fkin b\u00fcy\u00fck resmi g\u00f6steren infografi\u011fi<\/a> inceleyebilirsiniz.<\/p>\n

Kaynak: Integrating PostgreSQL Part 5: Security Integration<\/a>, EDB Ekibi Haziran 28, 2021
\n\u00a9 Copyright EnterpriseDB Corporation 2020 EnterpriseDB Corporation
\n34 Crosby Drive Suite 201 Bedford, MA 01730
\nEnterpriseDB and Postgres Enterprise Manager are registered trademarks of EnterpriseDB Corporation. EDB and EDB Postgres are trademarks of EnterpriseDB Corporation. Oracle is a registered trademark of Oracle, Inc. Other trademarks may be trademarks of their respective owners.<\/p>","protected":false},"excerpt":{"rendered":"

PostgreSQL Entegrasyonu blog serisinin s\u0131radaki b\u00f6l\u00fcm\u00fcnde kurumlar\u0131n daha fazla ve h\u0131zl\u0131 \u00e7al\u0131\u015fmas\u0131na yard\u0131mc\u0131 olabilecek PostgreSQL entegrasyonunu ke\u015ffetmeye devam ediyoruz. Bu blog yaz\u0131s\u0131 bir sonraki \u00f6nemli alan olan g\u00fcvenlik entegrasyonuna odaklanacak. G\u00fcvenlik Entegrasyonu PostgreSQL g\u00fcvenli\u011fi veri merkezi veya bulut ba\u011flam\u0131nda g\u00f6r\u00fclmelidir….<\/p>","protected":false},"author":16,"featured_media":22104,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[75,45],"tags":[58,48,50],"class_list":["post-18945","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-postgresql","category-yazi","tag-acikkaynak","tag-enterprisedb","tag-veritabani"],"_links":{"self":[{"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/posts\/18945","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/users\/16"}],"replies":[{"embeddable":true,"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/comments?post=18945"}],"version-history":[{"count":0,"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/posts\/18945\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/media\/22104"}],"wp:attachment":[{"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/media?parent=18945"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/categories?post=18945"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/tags?post=18945"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}