<?xml version="1.0" encoding="UTF-8"?><rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:atom="http://www.w3.org/2005/Atom" version="2.0" xmlns:cc="http://cyber.law.harvard.edu/rss/creativeCommonsRssModule.html">
    <channel>
        <title><![CDATA[Stories by mustafa avsever on Medium]]></title>
        <description><![CDATA[Stories by mustafa avsever on Medium]]></description>
        <link>https://medium.com/@mavsever?source=rss-293a4596e206------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/0*uf5K5WGl5DoFvBSu.jpg</url>
            <title>Stories by mustafa avsever on Medium</title>
            <link>https://medium.com/@mavsever?source=rss-293a4596e206------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Fri, 20 Nov 2026 15:44:58 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@mavsever/feed" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[Critical Update for Symantec DLP Users: Upgrade MPKI to Maintain Uninterrupted Service]]></title>
            <link>https://medium.com/@mavsever/critical-update-for-symantec-dlp-users-upgrade-mpki-to-maintain-uninterrupted-service-1dba27fe0b1e?source=rss-293a4596e206------2</link>
            <guid isPermaLink="false">https://medium.com/p/1dba27fe0b1e</guid>
            <dc:creator><![CDATA[mustafa avsever]]></dc:creator>
            <pubDate>Wed, 30 Jul 2025 07:29:49 GMT</pubDate>
            <atom:updated>2025-07-30T07:29:49.326Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/365/1*thoRal02i5LGzHTMWiZogQ.jpeg" /></figure><p>An important change is on the horizon for organizations using Broadcom’s Symantec Data Loss Prevention (DLP) solution. The current Managed Public Key Infrastructure (MPKI) service will be retired in <strong>August 2025</strong>. This change directly affects how DLP Cloud Bundles are validated and how certificates are renewed.</p><p>So, what does this mean for you? What steps should you take? Let’s break it down.</p><h4>1. What is MPKI and Why Is It Important?</h4><p>Symantec DLP uses the MPKI service to validate Cloud Bundles and automatically renew certificates during communication with the DLP Cloud. This service is critical for maintaining secure and uninterrupted operations between the DLP Enforce Server and the cloud.</p><h4>2. What’s Changing?</h4><p>To address the limitations of the current MPKI service, Broadcom is launching a new MPKI infrastructure. Once the transition is complete, the legacy MPKI service will be discontinued in August 2025.</p><p><strong>👉 📅 Before that date:</strong></p><p>You must apply the appropriate DLP hot fix to support the new MPKI service. Otherwise, Cloud Bundle updates and certificate renewals may fail.</p><h4>3. Which DLP Versions Are Affected?</h4><p>To help you quickly identify the required hot fix for your Symantec DLP environment, refer to the table below. It outlines which versions need the update, along with the exact file names for both Windows and Linux platforms. Ensure you download and install the correct package based on your current deployment version:</p><p>Use the table below to find the correct hot fix file for your DLP version and operating system.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/310/1*RNyfuaWYj50fSIGVrraVDQ.jpeg" /></figure><h4>4. Where to Download the Hot Fix?</h4><p>Go to the Symantec Enterprise Security Support site.</p><p>Click on My Downloads. In the search field, enter “Data Loss Prevention” and select the product.</p><p>Download the appropriate hot fix file for your DLP version and operating system:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/844/1*bp67aQ1kCeKcUUaAxFIzPA.jpeg" /></figure><h4>5. Risks of Skipping the Hot Fix ❗</h4><p>If you do not apply the hot fix:</p><p>· Cloud Bundles may become invalid.</p><p>· Automatic certificate renewal will fail.</p><p>· Communication between the DLP Cloud and the Enforce Server may be interrupted.</p><p>· Key DLP security functions may stop working.</p><p>· To maintain uninterrupted operation, it is strongly recommended to apply the hot fix as soon as possible.</p><h4>6-How to Apply Hotfix?</h4><p><strong><em>Step 1: Backup and Snapshot</em><br></strong> As with any update or patch, <strong>take full system backups and create snapshots</strong> before proceeding to ensure recovery in case of issues.</p><p><strong><em>Step 2: Understand the Hotfix Contents</em></strong><br>Each Folder contains <strong>three hotfix installer files</strong> for different components:</p><p><strong><em>Step 3: Identify Your Deployment Architecture</em></strong><br> Determine if your Symantec DLP deployment is <strong>Single Tier</strong> or <strong>Multi Tier</strong>:</p><ul><li>The easiest method is to check <strong>Programs and Features</strong> (Add/Remove Programs) on the server.</li><li>The installed application names will indicate the server role.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/510/1*C4xTAt3MQVd32mi6ri6YYg.jpeg" /></figure><p><strong><em>Step 4: Start the Installation on Desired Server(s)</em></strong></p><ul><li>For <strong>Enforce Server</strong> in Multi Tier setups, run the EnforceServer.msp.</li><li>For <strong>Single Tier</strong> deployments, run the SingleTierServer.msp</li><li>The installations are usually <strong>quick</strong>.</li><li>During installation, services will <strong>temporarily stop and start</strong>.</li></ul><p><strong><em>Step 6: Update All Detection Servers</em></strong></p><ul><li>After updating the Enforce Server, apply the DetectionServer.msp patch on all Detection Servers in your environment.</li><li>The OCR Server does not require this update, as it is not considered a Detection Server.</li></ul><p><strong><em>Step 7: Verify Hotfix Installation</em></strong></p><ul><li>Once all installations are complete, verify the hotfix application status on the <strong>Symantec DLP Overview</strong> screen.</li></ul><p><strong>Before update</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/802/1*yEXnfNGzQS79GsCib47J6g.jpeg" /></figure><p><strong>After update</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/801/1*TzFdgT6rPXUsty6CmqxkDA.jpeg" /></figure><h4>References</h4><p>1- <a href="https://knowledge.broadcom.com/external/article/401550">https://knowledge.broadcom.com/external/article/401550</a></p><p>2- <a href="https://support.broadcom.com/web/ecx/support-content-notification/-/external/content/ProductAdvisories/Upgrade-to-the-Latest-Managed-Public-Key-Infrastructure--MPKI--for-Data-Loss-Prevention-Cloud-Bundles/35836">https://support.broadcom.com/web/ecx/support-content-notification/-/external/content/ProductAdvisories/Upgrade-to-the-Latest-Managed-Public-Key-Infrastructure--MPKI--for-Data-Loss-Prevention-Cloud-Bundles/35836</a></p><p>3-https://chatgpt.com</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=1dba27fe0b1e" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Erstellen eines Benutzers mit eingeschränkten Berechtigungen für den OctoXLabs-Adapter in der…]]></title>
            <link>https://medium.com/@mavsever/erstellen-eines-benutzers-mit-eingeschr%C3%A4nkten-berechtigungen-f%C3%BCr-den-octoxlabs-adapter-in-der-488ff6c0f23b?source=rss-293a4596e206------2</link>
            <guid isPermaLink="false">https://medium.com/p/488ff6c0f23b</guid>
            <dc:creator><![CDATA[mustafa avsever]]></dc:creator>
            <pubDate>Sat, 26 Jul 2025 08:01:53 GMT</pubDate>
            <atom:updated>2025-07-26T08:01:53.676Z</atom:updated>
            <content:encoded><![CDATA[<h3>Erstellen eines Benutzers mit eingeschränkten Berechtigungen für den OctoXLabs-Adapter in der Symantec DLP Oracle-Datenbank</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/316/1*Rrx1wMYIgrVve9FCImXRMQ.png" /></figure><p><strong>1-Integration von OctoXLabs mit Symantec DLP:</strong></p><p>In der Welt der Cybersicherheit ist der Leitsatz „Was man nicht sehen kann, kann man nicht schützen“ längst nicht mehr nur eine Redewendung– er bildet die Grundlage für viele sicherheitsrelevante Investitionen in Unternehmen. Die ständig wachsenden digitalen Infrastrukturen, die steigende Anzahl von Nutzern sowie verteilte Systeme machen es für Sicherheitsteams unerlässlich, zunächst die Sichtbarkeit zu verbessern.</p><p>In diesem Artikel zeige ich schrittweise, wie die Plattform OctoXLabs mit Symantec DLP integriert wird, um die Sichtbarkeit zu erhöhen und das Incident Management zentral zu organisieren. Im Fokus steht die Erstellung eines dedizierten Benutzers mit eingeschränkten Rechten, der den standardmäßig vorhandenen, vollberechtigten Datenbankbenutzer „Protect“ ersetzt.</p><p><strong>2. Wie sorgt OctoXLabs die für mehr Überblick in der Cybersicherheit?</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/426/1*apSvqX_g8jfaERHy0FyTRA.png" /></figure><p>OctoXLabs ist eine Plattform für Sicherheitsvisualisierung, die sicherheitsrelevante Ereignisse zentral sammelt und auswertet. Sie klassifiziert DLP-Alarme, korreliert sie und liefert dem Management umsetzbare Erkenntnisse. In bestimmten Szenarien kann die Plattform sogar in Mechanismen zur Verhaltensanalyse oder Awareness-Schulungen eingebunden werden.</p><p><strong>3. Welche Daten ruft OctoXLabs aus Symantec DLP ab?</strong></p><p>Symantec DLP sammelt über installierte Agenten auf Endgeräten sicherheitsrelevante Daten und speichert sie in einer Oracle-Datenbank auf dem Enforce Server. Diese Daten werden von der DLP-Policy-Engine verwendet, können jedoch auch von Drittplattformen für Reporting, Inventarverwaltung oder Korrelation genutzt werden.</p><p>OctoXLabs greift mit speziell entwickelten Adaptern auf genau diese Daten zu. Dabei wird ein dedizierter Oracle-Benutzer mit reinen Lese-Rechten eingesetzt so bleibt die Systemstabilität jederzeit gewährleistet. Der Zugriff erfolgt hauptsächlich auf zwei Tabellen:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/665/1*iyZt6kMa2m769t5J6g4KQg.jpeg" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/665/1*2WdmebgvAFxkmdURT7BpwA.jpeg" /></figure><p><strong>4. Risiken bei Verwendung des „Protect“-Benutzers durch OctoXLabs</strong></p><p>Symantec DLP verwendet eine Oracle-Datenbank, in der der Benutzer „Protect“ mit umfassenden Zugriffsrechten auf sämtliche Daten angelegt ist. Ein Zugriff Dritter über diesen Benutzer ist nicht zu empfehlen, da dies nicht nur den Zugriff auf die benötigten Tabellen, sondern auch auf sensible Systemdaten ermöglichen würde. Die Erstellung eines Benutzers mit gezielten Lesezugriffsrechten stellt daher eine sicherere und nachhaltigere Lösung dar.</p><p><strong>5. Erstellen eines Benutzers mit eingeschränkten Rechten in der Symantec DLP Oracle-Datenbank</strong></p><p>Ziel ist es, einen dedizierten Benutzer mit ausschließlich lesendem Zugriff auf bestimmte Tabellen korrekt anzulegen. Vor dem Start sollte aus Sicherheitsgründen ein Datenbank-Backup bzw. Snapshot erstellt werden.</p><p><strong><em>5.1- Anmeldung an der Oracle-Datenbank über SQL</em></strong></p><p>Alle folgenden Schritte werden auf dem Enforce Server durchgeführt. Die Command Prompt wird mit Administratorrechten gestartet. Die Anmeldung erfolgt per :</p><blockquote><strong>sqlplus sys/&lt;Passwort&gt; as sysdba</strong></blockquote><figure><img alt="" src="https://cdn-images-1.medium.com/max/604/1*k7rX6L8o5nLmTOK-Cil79g.png" /></figure><p>Anschließend kann man sich mit folgendem Befehl alle Benutzer anzeigen lassen:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/649/1*4ASj0YS2_7WPTpkEYHrCwQ.png" /></figure><p><strong><em>5.2 — Benutzer für den OctoXLabs-Adapter erstellen</em></strong></p><p><strong>(username: octox_user Passwort: StrongPass123)</strong></p><p><strong>a-</strong> <strong>Benutzer erstellen:</strong></p><blockquote><strong>CREATE USER octox_user IDENTIFIED BY StrongPass123;</strong></blockquote><figure><img alt="" src="https://cdn-images-1.medium.com/max/462/1*FkPTwDU22uTTAX2KA_av1A.png" /></figure><p>Anschließend kann durch erneutes Abfragen der vorhandenen Benutzer überprüft werden, ob der Benutzer octox_user erfolgreich erstellt wurde.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/501/1*XuCsMXo_SOiU5ty759doLg.png" /></figure><p><strong>b– Anmeldeberechtigung gewähren:</strong></p><p>Mit den folgenden zwei Befehlen kann dem erstellten Benutzer die Berechtigung zur Anmeldung an der Datenbank erteilt werden:</p><blockquote><strong>GRANT CONNECT TO octox_user;</strong></blockquote><blockquote><strong>GRANT CREATE SESSION TO octox_user;</strong></blockquote><figure><img alt="" src="https://cdn-images-1.medium.com/max/338/1*Ianx5mWcDn7AfjSnQqpXBQ.png" /></figure><p><strong>c — SELECT-Rechte für benötigte Tabellen:</strong></p><p>OctoXLabs benötigt Zugriff auf AGENT und AGENTGROUP. Zunächst prüfen, wer der Eigentümer (Owner) der Tabellen ist:</p><blockquote><strong>SELECT owner, table_name FROM all_tables WHERE table_name IN (‘AGENT’, ‘AGENTGROUP’);</strong></blockquote><figure><img alt="" src="https://cdn-images-1.medium.com/max/665/1*MaWCT-HcMw-9EB_UgkRTCQ.png" /></figure><p>Nach dem Ausführen des Befehls kann festgestellt werden, dass der Eigentümer der Tabellen <strong>PROTECT</strong> ist.</p><p><strong><em>d — SELECT-Rechte auf die Tabellen gewähren:</em></strong></p><p>Mit den folgenden zwei Befehlen wird dem neu erstellten Benutzer Lesezugriff (Read-Only) auf die Tabellen erteilt.</p><blockquote><strong>GRANT SELECT ON PROTECT.AGENT TO octox_user;</strong></blockquote><blockquote><strong>GRANT SELECT ON PROTECT.AGENTGROUP TO octox_user;</strong></blockquote><figure><img alt="" src="https://cdn-images-1.medium.com/max/449/1*y_zHDFjTpS4mrYYoyzfD7g.png" /></figure><p><strong>e — Überprüfung der Rechte:</strong></p><p>Mit dem folgenden Befehl kann die erteilte Berechtigung überprüft werden:</p><blockquote><strong>SELECT * FROM DBA_TAB_PRIVS WHERE GRANTEE = ‘OCTOX_USER’ AND PRIVILEGE = ‘SELECT’;</strong></blockquote><p>Hinweis: Die Ausgabe ist technisch und schwer lesbar — zur besseren Analyse kann man Tools wie ChatGPT nutzen.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/665/1*_ffTNcpisYBUIEGI8Y08Rw.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/665/1*gbCiicWXT34WiR3_dXVNxA.png" /><figcaption>ChatGPT-Bild</figcaption></figure><p><strong>6. Überprüfung des neuen Benutzers:</strong></p><p>Bisher wurden alle durchgeführten Schritte mit dem Benutzer <strong>Protect</strong> ausgeführt. Öffnen wir nun ein neues Kommandozeilenfenster und führen unsere Tests mit dem neu erstellten Benutzer <strong>octox_user</strong> durch.</p><p><strong>6.1 — Anmeldung mit dem neuen Benutzer:</strong></p><blockquote><strong>sqlplus octox_user/StrongPass123</strong></blockquote><figure><img alt="" src="https://cdn-images-1.medium.com/max/663/1*9TK8NJ1qqrKVfQ9FsdCeMQ.png" /></figure><p><strong>6.2 — Datenabfrage aus den Tabellen AGENT und AGENTGROUP</strong></p><p>Um den Zugriff auf beide Tabellen zu bestätigen, werden in diesem Schritt jeweils die ersten fünf Zeilen abgefragt.</p><blockquote><strong>SELECT * FROM PROTECT.AGENT FETCH FIRST 5 ROWS ONLY;</strong></blockquote><figure><img alt="" src="https://cdn-images-1.medium.com/max/641/1*F4xPwICkqlMxNiZbkvnn0w.png" /></figure><blockquote><strong>SELECT * FROM PROTECT.AGENTGROUP FETCH FIRST 5 ROWS ONLY;</strong></blockquote><figure><img alt="" src="https://cdn-images-1.medium.com/max/652/1*i_F9-F3x0cVRbbP7USFyzw.png" /></figure><p>Die Ausgaben bestätigen, dass octox_user erfolgreich auf beide Tabellen zugreifen kann.</p><p><strong>7- Fazit</strong></p><p>Durch die definierte Rechtevergabe ist es möglich, OctoXLabs einen sicheren Zugriff auf die benötigten Daten in der Oracle-Datenbank von Symantec DLP zu ermöglichen — ohne unnötige Berechtigungen zu vergeben.</p><p><strong>Quellen:</strong></p><p>1-https://www.octoxlabs.com/</p><p>2-https://www.broadcom.com/products/cybersecurity/information-protection/data-loss-prevention</p><p>3-https://www.oracle.com/</p><p>4-https://chatgpt.com</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=488ff6c0f23b" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Symantec DLP Oracle Veritabanında OctoXLabs Adaptörü için Kısıtlı Yetkili Kullanıcı Oluşturma]]></title>
            <link>https://medium.com/@mavsever/symantec-dlp-oracle-veritaban%C4%B1nda-octoxlabs-adapt%C3%B6r%C3%BC-i%C3%A7in-k%C4%B1s%C4%B1tl%C4%B1-yetkili-kullan%C4%B1c%C4%B1-olu%C5%9Fturma-097058719c68?source=rss-293a4596e206------2</link>
            <guid isPermaLink="false">https://medium.com/p/097058719c68</guid>
            <dc:creator><![CDATA[mustafa avsever]]></dc:creator>
            <pubDate>Sat, 28 Jun 2025 11:51:22 GMT</pubDate>
            <atom:updated>2025-06-28T12:06:06.794Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/316/1*UH-rZ7vtsbAYcQ5Nq1en9w.jpeg" /></figure><h3>1. OctoXlabs ile Symantec DLP Entegrasyonu:</h3><p>Siber güvenlik dünyasında “Göremediğini yönetemezsin” sözü artık sadece bir motto değil, kurumsal güvenlik yatırımlarının temel dayanağı haline geldi. Giderek genişleyen dijital altyapılar, artan kullanıcı sayısı ve dağıtık sistemler; güvenlik ekiplerinin öncelikli olarak görünürlük sorununu çözmesini zorunlu kılıyor.</p><p>Bu yazıda, görünürlüğü artırmak ve olay yönetimini merkezi hale getirmek amacıyla geliştirilen OctoXlabs platformunun, Symantec DLP ile nasıl entegre edildiğini adım adım anlatacağım. Yazının ana odağında; varsayılan olarak gelen tam yetkili “Protect” veritabanı kullanıcısının yerine, sadece gerekli yetkilere sahip özel bir kullanıcı hesabı oluşturulması bulunuyor.</p><h3>2. OctoXlabs: Siber Güvenlikte Görünürlüğü Nasıl Artırır?</h3><p>OctoXlabs, veri güvenliği olaylarını merkezi olarak toplayıp analiz etmeye yarayan bir güvenlik görünürlük platformudur. Özellikle DLP çözümlerinden gelen veri sızıntısı alarmlarını sınıflandırır, korelasyon sağlar ve yönetime anlamlı içgörüler sunar. Bazı senaryolarda kullanıcı davranış analizi ve farkındalık artırıcı geri bildirim mekanizmalarıyla da entegre çalışabilir.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/425/1*McEOix0na40-Pv3mhmfxKA.jpeg" /><figcaption><strong>OctoXLabs Dashboard</strong></figcaption></figure><h3>3. OctoXlabs, Symantec DLP’den Hangi Verileri Çeker?</h3><p>Symantec DLP, son kullanıcı cihazlarına kurulan ajanlar (agent) aracılığıyla Endpointlerden topladığı çeşitli verileri, Enforce Server üzerinde çalışan Oracle veritabanına kaydeder. Bu veriler, Symantec DLP’nin kendi politika motoru ve analiz süreçleri tarafından kullanıldığı gibi, farklı platformlar tarafından da raporlama, envanter yönetimi veya korelasyon amacıyla değerlendirilebilir.</p><p>Bu noktada devreye giren OctoXlabs, envanter analizi amacıyla geliştirilmiş adaptörleri sayesinde bu verileri güvenli bir şekilde çekebilmektedir. OctoXlabs, yalnızca okuma (read-only) yetkisine sahip özel bir Oracle kullanıcısı tanımlayarak, sistem bütünlüğünü riske atmadan veri erişimini mümkün kılar. Platform, aşağıda belirtilen iki tablo üzerinden ihtiyaç duyduğu verileri alır:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/667/1*-clY4owQcZJ09oUOV20s8w.jpeg" /><figcaption><strong>Oracle Agentgroup Table</strong></figcaption></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/667/1*HUabnEhByeTFObutSujsNA.jpeg" /><figcaption><strong>Oracle Agent Table</strong></figcaption></figure><h3>4. OctoXlabs’in “Protect” Hesabını Kullanmasının Sakıncaları</h3><p>Symantec DLP, Oracle tabanlı bir veritabanı kullanır ve kurulumla birlikte, tüm yetkilere sahip <strong>“Protect”</strong> adlı varsayılan bir kullanıcı oluşturulur. Üçüncü parti uygulamaların bu kullanıcı üzerinden veritabanına erişmesi önerilmez; çünkü bu hesap aracılığıyla yalnızca ihtiyaç duyulan tablolar değil, sistemdeki diğer hassas verilere de erişim mümkün olabilir. Bu nedenle, yalnızca belirli tablolara erişim yetkisi olan, sınırlı yetkili bir kullanıcı tanımlanması, daha güvenli ve sürdürülebilir bir yaklaşımdır.</p><h3>5. Symantec DLP Oracle Veritabanında Sınırlı Yetkili Kullanıcı Oluşturma</h3><p>Bu bölümde, yukarıda değinilen güvenli erişim yaklaşımını hayata geçirmek için Symantec DLP Oracle veritabanında sınırlı yetkili bir kullanıcı oluşturma adımlarını paylaşacağım. Amaç, yalnızca gerekli tablolar üzerinde okuma yetkisine sahip bir hesabın doğru şekilde tanımlanmasını sağlamaktır.</p><blockquote>İşleme geçmeden önce, olası veri kaybı risklerine karşı <strong>veritabanı yedeği (backup) ve snapshot</strong> alınması her kritik uygulamada olduğu gibi burada da önerilir. Bu sayede, beklenmeyen durumlarda sistem geri dönüşü sağlamak mümkün olacaktır.</blockquote><h3>5.1-SQL veritabanını giriş:</h3><p>Tüm adımlarımızı Symantec DLP’nin kurulum olduğu Enforce server’da gerçekleştiriyoruz. Enforce serverde Komut satırı ekranını Administrator/yönetici olarak açıyoruz ve aşağıdaki kod ile SQL veritabanına giriş yapıyoruz. SQL veritabanına girişte protect kullanıcısına ait parolayı kullanabiliriz.</p><p><strong>sqlplus sys/&lt;Parola&gt; as sysdba</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/604/1*rZwxFy_SalRm7oJVduPJ-A.jpeg" /></figure><p>Giriş yaptıktan sonra “<strong>SELECT USERNAME FROM DBA_USERS ORDER BY USERNAME;</strong> ” komutu ile mevcut kullanıcıları görüntüleyebiliriz.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/604/1*rZwxFy_SalRm7oJVduPJ-A.jpeg" /></figure><p><strong>5.2-OctoXlabs adaptörü için yeni kullanıcı oluşturma adımları:</strong></p><p><strong><em>(username: octox_user Parola : StrongPass123)</em></strong></p><p><strong>a-Kullanıcı oluşturma:</strong></p><p><strong>CREATE USER octox_user IDENTIFIED BY StrongPass123;</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/462/1*BXlVuw8tZenYi2P6tOFPSA.jpeg" /></figure><p>Sonrasında tekrar mevcut kullanıcıları kontrol ettiğimizde octox_user kullanıcısının oluştuğunu görebiliriz.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/501/1*XuCsMXo_SOiU5ty759doLg.png" /></figure><p><strong>b-Oturum açma yetkisi verme:</strong></p><p>Aşağıdaki iki komut ile oluşturulan user’a oturum açma yetkisi verebiliriz.</p><p><strong>GRANT CONNECT TO octox_user;</strong></p><p><strong>GRANT CREATE SESSION TO octox_user;</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/338/1*NbNcfgWEqKlHgvt-eGk4Ww.jpeg" /></figure><p><strong>c- Tablolara SELECT (Read Only) yetkisi verme:</strong></p><p>Üst kısımda belirttiğimiz gibi adaptörün hangi tablolardan veri çekeceğini bu adımda yapıyoruz. Bu kısımda OctoXlabs tarafından talep edilen tablolar AGENT ve AGENTGROUP tablolarıdır. Veritabanında erişim yetkisi alırken tabloların sahibi-owner’ı bulmak gereklidir.</p><p>Aşağıdaki komut ile bunu kolayca öğrenebiliriz.</p><p><strong>SELECT owner, table_name FROM all_tables WHERE table_name IN (‘AGENT’, ‘AGENTGROUP’);</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/665/1*mXl0uhCNAydx1JcD7BRElA.jpeg" /></figure><p>Komutu çalıştırdıktan sonra tabloların sahibinin PROTECT olduğunu görebiliriz.</p><p><strong>d-AGENT ve AGENTGROUP şemalarina read yetkisi verme</strong></p><p>Aşağıdaki 2 komut ile yeni oluşturulan kullanıcıya read only yetkisi veririz.</p><p><strong>GRANT SELECT ON PROTECT.AGENT TO octox_user;</strong></p><p><strong>GRANT SELECT ON PROTECT.AGENTGROUP TO octox_user;</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/449/1*-yWoz3z6sHEpJDogZp1aBA.jpeg" /></figure><p>Aşağıdaki komut ile verilen yetkiyi kontrol edebiliriz.</p><p><strong>SELECT * FROM DBA_TAB_PRIVS WHERE GRANTEE = ‘OCTOX_USER’ AND PRIVILEGE = ‘SELECT’;</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/665/1*zGpgDcRhxaV4rzq0z-IEyQ.jpeg" /></figure><p>Komut çalıştırıldığında çıktılar ham ve zor okunabilir formatta olacaktır. Ancak ChatGPT desteğiyle bu loglar daha anlamlı ve yorumlanabilir bir hale getirilebilir.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/667/1*Xev6aaYJEAZneFFb6Tqecw.jpeg" /><figcaption>ChatGPT Ham verilerin çıktısı</figcaption></figure><h3>6. Yeni Kullanıcı Kontrolleri:</h3><p>Şu ana kadar yaptığımız tüm işlemleri <strong>Protect</strong> kullanıcısı üzerinden yaptık. Yeni bir komut satırı ekranı açarak yeni oluşturulan octox_user kullanıcısı üzerinden testlerimizi yapalım.</p><p><strong>6.1-SQL veritabanına giriş:</strong></p><p><strong>sqlplus octox_user/StrongPass123</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/663/1*bPNy1i9g_o7Zra0X0su3sw.jpeg" /></figure><p><strong>6.2-AGENT ve AGENTGROUP tablolarından veri okuma</strong></p><p>Her iki tabloya erişimin sağlandığını doğrulamak adına, bu adımda her birinden ilk 5 satırın sorgulanmasını sağlayalım.</p><p><strong>SELECT * FROM PROTECT.AGENT FETCH FIRST 5 ROWS ONLY;</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/641/1*RTrgllI2VsG7Q3GEiZ1u3w.jpeg" /></figure><p><strong>SELECT * FROM PROTECT.AGENTGROUP FETCH FIRST 5 ROWS ONLY;</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/641/1*F4xPwICkqlMxNiZbkvnn0w.png" /></figure><p>Yukarıdaki resimlerde de görüldüğü gibi octox_user her iki tablodanda veri okuması yapabilmektetir.</p><h3>7- Sonuç</h3><p>Gerçekleştirilen yetkilendirme sayesinde, yalnızca gerekli yetkilere sahip olacak şekilde tanımlanan kullanıcı hesabı ile OctoXlabs, Oracle veritabanına güvenli bir şekilde bağlanarak ihtiyaç duyduğu verileri başarıyla okuyabilmektedir.</p><h3>Kaynaklar</h3><p><strong>1</strong>-https://www.octoxlabs.com/</p><p><strong>2</strong>-https://www.broadcom.com/products/cybersecurity/information-protection/data-loss-prevention</p><p><strong>3</strong>-https://www.oracle.com/</p><p><strong>4</strong>-https://chatgpt.com</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=097058719c68" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>