{"id":321,"date":"2026-06-25T18:00:00","date_gmt":"2026-06-25T16:00:00","guid":{"rendered":"https:\/\/blog.agdba.de\/?p=321"},"modified":"2026-06-25T22:01:56","modified_gmt":"2026-06-25T20:01:56","slug":"step-by-step-guide-sql-firewall-in-oci-datasafe-konfigurieren","status":"publish","type":"post","link":"https:\/\/blog.agdba.de\/?p=321","title":{"rendered":"Step-by-Step Guide: SQL Firewall in OCI Datasafe konfigurieren"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Wie in einem anderen Post beschrieben, kann in der Oracle Database 23ai\/26ai die SQL Firewall verwendet werden. Neben der Konfiguration mittels PL\/SQL-Package, kann es auch in der OCI mittels Datasafe verwendet werden.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Dieser Step-by-Step Guide soll die Vorbereitung und Einrichtung der SQL-Firewall in OCI Datasafe zeigen.<\/p>\n\n\n\n<!--more-->\n\n\n\n<h3 class=\"wp-block-heading\">1. Hinzuf\u00fcgen der Target im Datasafe<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Um eine Datenbank oder PDB in Datasafe f\u00fcr beispielsweise die SQL Firewall nutzen zu k\u00f6nnen, muss die Datenbank\/PDB in Datasafe als Target hinzugef\u00fcgt werden.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Dazu im Bereich &#8222;Oracle AI Database&#8220; auf &#8222;Data Safe &#8211; Database Security&#8220; &#8211;&gt; &#8222;Overview&#8220;:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"566\" src=\"https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-202030-4-1024x566.png\" alt=\"\" class=\"wp-image-327\" srcset=\"https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-202030-4-1024x566.png 1024w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-202030-4-300x166.png 300w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-202030-4-768x424.png 768w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-202030-4-700x387.png 700w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-202030-4-724x400.png 724w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-202030-4.png 1311w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Dann auf &#8222;Target databases&#8220; &#8211;&gt; &#8222;Register database via wizard&#8220;<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"941\" height=\"542\" src=\"https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-202124-1.png\" alt=\"\" class=\"wp-image-328\" srcset=\"https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-202124-1.png 941w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-202124-1-300x173.png 300w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-202124-1-768x442.png 768w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-202124-1-700x403.png 700w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-202124-1-694x400.png 694w\" sizes=\"auto, (max-width: 941px) 100vw, 941px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Anschlie\u00dfend in dem entsprechenden Bereich &#8222;Start wizard&#8220;. Im Beispiel ist es ein Base Database Service, daher start ich den Wizart im Bereich &#8222;Oracle cloud databases&#8220;:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"430\" src=\"https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-202201-1-1024x430.png\" alt=\"\" class=\"wp-image-329\" srcset=\"https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-202201-1-1024x430.png 1024w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-202201-1-300x126.png 300w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-202201-1-768x323.png 768w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-202201-1-1536x646.png 1536w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-202201-1-700x294.png 700w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-202201-1-951x400.png 951w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-202201-1.png 1746w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Im sich \u00f6ffnenden Fenster k\u00f6nnen dann das Compartment, das DB System und die PDB ausgew\u00e4hlt werden:<\/p>\n\n\n\n<figure class=\"wp-block-gallery has-nested-images columns-default is-cropped wp-block-gallery-1 is-layout-flex wp-block-gallery-is-layout-flex\">\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1146\" height=\"645\" data-id=\"333\" src=\"https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-202345-1-edited.png\" alt=\"\" class=\"wp-image-333\" srcset=\"https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-202345-1-edited.png 1146w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-202345-1-edited-300x169.png 300w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-202345-1-edited-1024x576.png 1024w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-202345-1-edited-768x432.png 768w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-202345-1-edited-700x394.png 700w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-202345-1-edited-711x400.png 711w\" sizes=\"auto, (max-width: 1146px) 100vw, 1146px\" \/><\/figure>\n<\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"423\" src=\"https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-202418-1024x423.png\" alt=\"\" class=\"wp-image-331\" srcset=\"https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-202418-1024x423.png 1024w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-202418-300x124.png 300w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-202418-768x317.png 768w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-202418-700x289.png 700w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-202418-969x400.png 969w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-202418.png 1189w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Dann muss f\u00fcr Datasafe ein Benutzer in der PDB angelegt werden. Um die richtigen Berechtigungen zu vergeben, muss das Script datasafe_privileges.sql heruntergeladen und ausgef\u00fchrt werden:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"232\" src=\"https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-202831-1024x232.png\" alt=\"\" class=\"wp-image-335\" srcset=\"https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-202831-1024x232.png 1024w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-202831-300x68.png 300w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-202831-768x174.png 768w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-202831-1536x349.png 1536w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-202831-700x159.png 700w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-202831.png 1639w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Anlege und Berechtigen des Benutzers DATASAFE_ADMIN in der PDB:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SQL&gt; alter session set container=PDB_SQLFW;\n\nSession altered.\n\nSQL&gt; CREATE USER DATASAFE_ADMIN identified by \"SQLFW_demo#2026\"\nDEFAULT TABLESPACE \"USERS\"\nTEMPORARY TABLESPACE \"TEMP\";\n  2    3\nUser created.\n\nSQL&gt; GRANT CONNECT, RESOURCE TO DATASAFE_ADMIN;\nGrant succeeded.\n\nSQL&gt; @datasafe_privileges.sql DATASAFE_ADMIN GRANT ALL\nEnter value for USERNAME (case sensitive matching the username from dba_users)\nSetting USERNAME to DATASAFE_ADMIN\nEnter value for TYPE (grant\/revoke)\nSetting TYPE to GRANT\nEnter value for MODE (audit_collection\/audit_setting\/data_discovery\/masking\/assessment\/sql_firewall\/all)\nSetting MODE to ALL\n\nGranting AUDIT_COLLECTION privileges to \"DATASAFE_ADMIN\" ...\n\"ORA_DSCS_AUDIT_COLLECTION\"\nCreated role \"ORA_DSCS_AUDIT_COLLECTION\"\n\nGranting AUDIT_SETTING privileges to \"DATASAFE_ADMIN\" ...\n\"ORA_DSCS_AUDIT_SETTING\"\nCreated role \"ORA_DSCS_AUDIT_SETTING\"\nGranting SQL_FIREWALL privileges to \"DATASAFE_ADMIN\" ...\n\"ORA_DSCS_SQL_FIREWALL\"\nCreated role \"ORA_DSCS_SQL_FIREWALL\"\n\nGranting DATA_DISCOVERY role to \"DATASAFE_ADMIN\" ...\n\"ORA_DSCS_DATA_DISCOVERY\"\nCreated role \"ORA_DSCS_DATA_DISCOVERY\"\n\nGranting MASKING role to \"DATASAFE_ADMIN\" ...\n\"ORA_DSCS_MASKING\"\nCreated role \"ORA_DSCS_MASKING\"\n\nGranting ASSESSMENT role to \"DATASAFE_ADMIN\" ...\n\"ORA_DSCS_ASSESSMENT\"\nCreated role \"ORA_DSCS_ASSESSMENT\"\nDisconnected from Oracle AI Database 26ai EE High Perf Release 23.26.2.0.0 - Production\nVersion 23.26.2.0.0<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Alternativ k\u00f6nnte auch nur SQL_FIREWALL statt ALL angegeben werden, wenn keine andere Funktionen in Datasafe genutzt werden sollen:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SQL&gt; @datasafe_privileges.sql DATASAFE_ADMIN GRANT SQL_FIREWALL\nEnter value for USERNAME (case sensitive matching the username from dba_users)\nSetting USERNAME to DATASAFE_ADMIN\nEnter value for TYPE (grant\/revoke)\nSetting TYPE to GRANT\nEnter value for MODE (audit_collection\/audit_setting\/data_discovery\/masking\/assessment\/sql_firewall\/all)\nSetting MODE to SQL_FIREWALL\nGranting SQL_FIREWALL privileges to \"DATASAFE_ADMIN\" ...\n\"ORA_DSCS_SQL_FIREWALL\"<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Dann muss im Registration Wizard noch ein Private Endpoint im Subnet angelegt oder ausgew\u00e4hlt werden. In meinem Fall habe ich bereits einen und w\u00e4hle ihn aus. Der Wizard kann auch einen anlegen, wenn keiner vorhanden ist.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"910\" height=\"487\" src=\"https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-202846.png\" alt=\"\" class=\"wp-image-337\" srcset=\"https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-202846.png 910w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-202846-300x161.png 300w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-202846-768x411.png 768w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-202846-700x375.png 700w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-202846-747x400.png 747w\" sizes=\"auto, (max-width: 910px) 100vw, 910px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Im letzten Abschnitt werden noch die Security Lists ausgew\u00e4hlt, in welchen die entsprechenden Ingress und Egress Rules eingetragen werden sollen:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"703\" src=\"https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-202920-1024x703.png\" alt=\"\" class=\"wp-image-338\" srcset=\"https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-202920-1024x703.png 1024w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-202920-300x206.png 300w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-202920-768x528.png 768w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-202920-700x481.png 700w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-202920-582x400.png 582w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-202920.png 1236w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"640\" src=\"https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-203000-1024x640.png\" alt=\"\" class=\"wp-image-339\" srcset=\"https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-203000-1024x640.png 1024w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-203000-300x187.png 300w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-203000-768x480.png 768w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-203000-700x437.png 700w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-203000-640x400.png 640w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-203000.png 1228w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Dann kann die PDB als Target registiert werden. Anschlie\u00dfend ist das Target wie folgt im Datasafe:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"524\" src=\"https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-203040-1-1024x524.png\" alt=\"\" class=\"wp-image-340\" srcset=\"https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-203040-1-1024x524.png 1024w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-203040-1-300x154.png 300w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-203040-1-768x393.png 768w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-203040-1-1536x786.png 1536w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-203040-1-700x358.png 700w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-203040-1-781x400.png 781w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-203040-1.png 1879w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Zu sehen sind unter anderem auch, welche Berechtigungen der DATASAFE_ADMIN User bekommen hat.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">2. SQL-Firewall aktivieren<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Im Bereich Datasafe &#8211;&gt; SQL Firewall kann die SQL Firewall f\u00fcr die Targets aktiviert werden. Dazu muss im Bereich &#8222;Target summary&#8220; die Target Database ausgew\u00e4hlt werden:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"349\" src=\"https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-203115-1024x349.png\" alt=\"\" class=\"wp-image-341\" srcset=\"https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-203115-1024x349.png 1024w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-203115-300x102.png 300w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-203115-768x262.png 768w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-203115-1536x524.png 1536w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-203115-700x239.png 700w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-203115-1172x400.png 1172w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-203115.png 1644w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Dann kann oben rechts die SQL Firewall aktiviert werden:<\/p>\n\n\n\n<figure class=\"wp-block-gallery has-nested-images columns-default is-cropped wp-block-gallery-2 is-layout-flex wp-block-gallery-is-layout-flex\">\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"382\" data-id=\"343\" src=\"https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-203134-1-1024x382.png\" alt=\"\" class=\"wp-image-343\" srcset=\"https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-203134-1-1024x382.png 1024w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-203134-1-300x112.png 300w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-203134-1-768x287.png 768w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-203134-1-1536x574.png 1536w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-203134-1-700x261.png 700w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-203134-1-1071x400.png 1071w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-203134-1.png 1540w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">3. SQL Collection erstellen und starten<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Um eine Colletion f\u00fcr SQLs und Context zu starten, kann im Bereich &#8222;SQL collections&#8220; die Collection erzeugt und gestartet werden:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"908\" height=\"731\" src=\"https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-203251.png\" alt=\"\" class=\"wp-image-344\" srcset=\"https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-203251.png 908w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-203251-300x242.png 300w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-203251-768x618.png 768w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-203251-700x564.png 700w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-203251-497x400.png 497w\" sizes=\"auto, (max-width: 908px) 100vw, 908px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Es \u00f6ffnet sich folgendes Fenster f\u00fcr die Konfiguration der Collection, wo der Benutzer ausgew\u00e4hlt werden kann und ob es eine Top-level Collection ist, oder nicht:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"516\" src=\"https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-203318-1024x516.png\" alt=\"\" class=\"wp-image-345\" srcset=\"https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-203318-1024x516.png 1024w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-203318-300x151.png 300w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-203318-768x387.png 768w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-203318-1536x773.png 1536w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-203318-700x352.png 700w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-203318-795x400.png 795w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-203318.png 1883w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Anschlie\u00dfend kann f\u00fcr den Benutzer APP der SQL Workload ausgef\u00fchrt werden, der sp\u00e4ter erlaubt sein soll.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In den SQL Insights sind die Inhalte der Collection zu sehen:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"642\" src=\"https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-203850-1024x642.png\" alt=\"\" class=\"wp-image-346\" srcset=\"https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-203850-1024x642.png 1024w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-203850-300x188.png 300w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-203850-768x481.png 768w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-203850-700x439.png 700w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-203850-638x400.png 638w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-203850.png 1509w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">4. Firewall Policy erstellen<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Sobald der Testzeitraum abgeschlossen ist, oder die Unique SQL Statements wieder gegen 0 sind, kann die Collection \u00fcber &#8222;Actions&#8220; &#8211;&gt; &#8222;Stop&#8220; wieder gestoppt werden.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Anschlie\u00dfend kann aus der Collection eine Firewall Policy erstellt werden: &#8222;Actions&#8220; &#8211;&gt; &#8222;Genereate firewall policy&#8220;:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"315\" src=\"https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-203949-1024x315.png\" alt=\"\" class=\"wp-image-347\" srcset=\"https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-203949-1024x315.png 1024w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-203949-300x92.png 300w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-203949-768x236.png 768w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-203949-700x216.png 700w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-203949-1299x400.png 1299w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-203949.png 1520w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">In dieser Collection sind dann die erfassten SQL und Konext Informationen zu sehen:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"602\" src=\"https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-204028-1024x602.png\" alt=\"\" class=\"wp-image-348\" srcset=\"https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-204028-1024x602.png 1024w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-204028-300x176.png 300w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-204028-768x452.png 768w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-204028-700x412.png 700w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-204028-680x400.png 680w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-204028.png 1518w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"524\" src=\"https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-204041-1024x524.png\" alt=\"\" class=\"wp-image-349\" srcset=\"https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-204041-1024x524.png 1024w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-204041-300x153.png 300w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-204041-768x393.png 768w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-204041-700x358.png 700w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-204041-782x400.png 782w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-204041.png 1504w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\u00dcber den Button &#8222;Deploy and enforce&#8220; kann dann die Policy aktiviert werden. Dazu k\u00f6nnen ein paar Parameter nach Wunsch und Anforderung eingestellt werden:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"644\" src=\"https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-204125-1024x644.png\" alt=\"\" class=\"wp-image-351\" srcset=\"https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-204125-1024x644.png 1024w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-204125-300x189.png 300w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-204125-768x483.png 768w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-204125-1536x966.png 1536w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-204125-700x440.png 700w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-204125-636x400.png 636w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-204125.png 1538w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">In diesem Fall werden SQL Statements und Session Kontext \u00fcberpr\u00fcft und auch geblockt, wo etwas nicht erlaubt ist.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">5. Monitor Violations<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Unter &#8222;Violation reports&#8220; k\u00f6nnen dann SQL- und Kontext-Violations \u00fcberwacht werden:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"407\" src=\"https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-204424-1024x407.png\" alt=\"\" class=\"wp-image-352\" srcset=\"https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-204424-1024x407.png 1024w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-204424-300x119.png 300w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-204424-768x305.png 768w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-204424-1536x611.png 1536w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-204424-700x278.png 700w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-204424-1006x400.png 1006w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-204424.png 1844w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Hier sind beispielsweise 3 SQLs zu sehen, die geblockt wurden.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Die Policy kann auch modifiziert werden. Entweder k\u00f6nnen aus Violations SQLs der Policy hinzugef\u00fcgt werden, oder auch session Kontext ver\u00e4ndert werden:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"511\" src=\"https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-204857-1024x511.png\" alt=\"\" class=\"wp-image-353\" srcset=\"https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-204857-1024x511.png 1024w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-204857-300x150.png 300w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-204857-768x383.png 768w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-204857-700x349.png 700w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-204857-802x400.png 802w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-204857.png 1493w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"690\" height=\"728\" src=\"https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-204939.png\" alt=\"\" class=\"wp-image-354\" srcset=\"https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-204939.png 690w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-204939-284x300.png 284w, https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-204939-379x400.png 379w\" sizes=\"auto, (max-width: 690px) 100vw, 690px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Neben der SQL Firewall gibt es noch mehrere andere Security Features im Datasafe, und auch onPremises Datenbanken k\u00f6nnen eingebunden werden.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Wie in einem anderen Post beschrieben, kann in der Oracle Database 23ai\/26ai die SQL Firewall verwendet werden. Neben der Konfiguration mittels PL\/SQL-Package, kann es auch in der OCI mittels Datasafe verwendet werden. Dieser Step-by-Step Guide soll die Vorbereitung und Einrichtung der SQL-Firewall in OCI Datasafe zeigen.<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1,13,15,14],"tags":[23,24,30,19,27,26,25],"class_list":["post-321","post","type-post","status-publish","format-standard","hentry","category-allgemein","category-database","category-oci","category-security","tag-23ai","tag-26ai","tag-datasafe","tag-oci","tag-oracle-database","tag-security","tag-sql-firewall"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.9 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Step-by-Step Guide: SQL Firewall in OCI Datasafe konfigurieren - agdba.de<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/blog.agdba.de\/?p=321\" \/>\n<meta property=\"og:locale\" content=\"de_DE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Step-by-Step Guide: SQL Firewall in OCI Datasafe konfigurieren - agdba.de\" \/>\n<meta property=\"og:description\" content=\"Wie in einem anderen Post beschrieben, kann in der Oracle Database 23ai\/26ai die SQL Firewall verwendet werden. Neben der Konfiguration mittels PL\/SQL-Package, kann es auch in der OCI mittels Datasafe verwendet werden. Dieser Step-by-Step Guide soll die Vorbereitung und Einrichtung der SQL-Firewall in OCI Datasafe zeigen.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/blog.agdba.de\/?p=321\" \/>\n<meta property=\"og:site_name\" content=\"agdba.de\" \/>\n<meta property=\"article:published_time\" content=\"2026-06-25T16:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-06-25T20:01:56+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-202030-4.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1311\" \/>\n\t<meta property=\"og:image:height\" content=\"724\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Alexander Giesbrecht\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Verfasst von\" \/>\n\t<meta name=\"twitter:data1\" content=\"Alexander Giesbrecht\" \/>\n\t<meta name=\"twitter:label2\" content=\"Gesch\u00e4tzte Lesezeit\" \/>\n\t<meta name=\"twitter:data2\" content=\"8\u00a0Minuten\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/blog.agdba.de\\\/?p=321#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/blog.agdba.de\\\/?p=321\"},\"author\":{\"name\":\"Alexander Giesbrecht\",\"@id\":\"https:\\\/\\\/blog.agdba.de\\\/#\\\/schema\\\/person\\\/c9b8806180cd864945b5950d3dec5798\"},\"headline\":\"Step-by-Step Guide: SQL Firewall in OCI Datasafe konfigurieren\",\"datePublished\":\"2026-06-25T16:00:00+00:00\",\"dateModified\":\"2026-06-25T20:01:56+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/blog.agdba.de\\\/?p=321\"},\"wordCount\":599,\"image\":{\"@id\":\"https:\\\/\\\/blog.agdba.de\\\/?p=321#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/blog.agdba.de\\\/wp-content\\\/uploads\\\/2026\\\/06\\\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-202030-4-1024x566.png\",\"keywords\":[\"23ai\",\"26ai\",\"Datasafe\",\"OCI\",\"Oracle Database\",\"Security\",\"SQL Firewall\"],\"articleSection\":{\"1\":\"Database\",\"2\":\"OCI\",\"3\":\"Security\"},\"inLanguage\":\"de\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/blog.agdba.de\\\/?p=321\",\"url\":\"https:\\\/\\\/blog.agdba.de\\\/?p=321\",\"name\":\"Step-by-Step Guide: SQL Firewall in OCI Datasafe konfigurieren - agdba.de\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/blog.agdba.de\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/blog.agdba.de\\\/?p=321#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/blog.agdba.de\\\/?p=321#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/blog.agdba.de\\\/wp-content\\\/uploads\\\/2026\\\/06\\\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-202030-4-1024x566.png\",\"datePublished\":\"2026-06-25T16:00:00+00:00\",\"dateModified\":\"2026-06-25T20:01:56+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/blog.agdba.de\\\/#\\\/schema\\\/person\\\/c9b8806180cd864945b5950d3dec5798\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/blog.agdba.de\\\/?p=321#breadcrumb\"},\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/blog.agdba.de\\\/?p=321\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\\\/\\\/blog.agdba.de\\\/?p=321#primaryimage\",\"url\":\"https:\\\/\\\/blog.agdba.de\\\/wp-content\\\/uploads\\\/2026\\\/06\\\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-202030-4.png\",\"contentUrl\":\"https:\\\/\\\/blog.agdba.de\\\/wp-content\\\/uploads\\\/2026\\\/06\\\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-202030-4.png\",\"width\":1311,\"height\":724},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/blog.agdba.de\\\/?p=321#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Start\",\"item\":\"https:\\\/\\\/blog.agdba.de\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Step-by-Step Guide: SQL Firewall in OCI Datasafe konfigurieren\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/blog.agdba.de\\\/#website\",\"url\":\"https:\\\/\\\/blog.agdba.de\\\/\",\"name\":\"agdba.de\",\"description\":\"Oracle Database, OCI and more\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/blog.agdba.de\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"de\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/blog.agdba.de\\\/#\\\/schema\\\/person\\\/c9b8806180cd864945b5950d3dec5798\",\"name\":\"Alexander Giesbrecht\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b0f7a24a2ab62199afeb3704ba03108c4a0b796d431d9342635095c0d1861e3b?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b0f7a24a2ab62199afeb3704ba03108c4a0b796d431d9342635095c0d1861e3b?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b0f7a24a2ab62199afeb3704ba03108c4a0b796d431d9342635095c0d1861e3b?s=96&d=mm&r=g\",\"caption\":\"Alexander Giesbrecht\"},\"url\":\"https:\\\/\\\/blog.agdba.de\\\/?author=2\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Step-by-Step Guide: SQL Firewall in OCI Datasafe konfigurieren - agdba.de","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/blog.agdba.de\/?p=321","og_locale":"de_DE","og_type":"article","og_title":"Step-by-Step Guide: SQL Firewall in OCI Datasafe konfigurieren - agdba.de","og_description":"Wie in einem anderen Post beschrieben, kann in der Oracle Database 23ai\/26ai die SQL Firewall verwendet werden. Neben der Konfiguration mittels PL\/SQL-Package, kann es auch in der OCI mittels Datasafe verwendet werden. Dieser Step-by-Step Guide soll die Vorbereitung und Einrichtung der SQL-Firewall in OCI Datasafe zeigen.","og_url":"https:\/\/blog.agdba.de\/?p=321","og_site_name":"agdba.de","article_published_time":"2026-06-25T16:00:00+00:00","article_modified_time":"2026-06-25T20:01:56+00:00","og_image":[{"width":1311,"height":724,"url":"https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-202030-4.png","type":"image\/png"}],"author":"Alexander Giesbrecht","twitter_card":"summary_large_image","twitter_misc":{"Verfasst von":"Alexander Giesbrecht","Gesch\u00e4tzte Lesezeit":"8\u00a0Minuten"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/blog.agdba.de\/?p=321#article","isPartOf":{"@id":"https:\/\/blog.agdba.de\/?p=321"},"author":{"name":"Alexander Giesbrecht","@id":"https:\/\/blog.agdba.de\/#\/schema\/person\/c9b8806180cd864945b5950d3dec5798"},"headline":"Step-by-Step Guide: SQL Firewall in OCI Datasafe konfigurieren","datePublished":"2026-06-25T16:00:00+00:00","dateModified":"2026-06-25T20:01:56+00:00","mainEntityOfPage":{"@id":"https:\/\/blog.agdba.de\/?p=321"},"wordCount":599,"image":{"@id":"https:\/\/blog.agdba.de\/?p=321#primaryimage"},"thumbnailUrl":"https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-202030-4-1024x566.png","keywords":["23ai","26ai","Datasafe","OCI","Oracle Database","Security","SQL Firewall"],"articleSection":{"1":"Database","2":"OCI","3":"Security"},"inLanguage":"de"},{"@type":"WebPage","@id":"https:\/\/blog.agdba.de\/?p=321","url":"https:\/\/blog.agdba.de\/?p=321","name":"Step-by-Step Guide: SQL Firewall in OCI Datasafe konfigurieren - agdba.de","isPartOf":{"@id":"https:\/\/blog.agdba.de\/#website"},"primaryImageOfPage":{"@id":"https:\/\/blog.agdba.de\/?p=321#primaryimage"},"image":{"@id":"https:\/\/blog.agdba.de\/?p=321#primaryimage"},"thumbnailUrl":"https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-202030-4-1024x566.png","datePublished":"2026-06-25T16:00:00+00:00","dateModified":"2026-06-25T20:01:56+00:00","author":{"@id":"https:\/\/blog.agdba.de\/#\/schema\/person\/c9b8806180cd864945b5950d3dec5798"},"breadcrumb":{"@id":"https:\/\/blog.agdba.de\/?p=321#breadcrumb"},"inLanguage":"de","potentialAction":[{"@type":"ReadAction","target":["https:\/\/blog.agdba.de\/?p=321"]}]},{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/blog.agdba.de\/?p=321#primaryimage","url":"https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-202030-4.png","contentUrl":"https:\/\/blog.agdba.de\/wp-content\/uploads\/2026\/06\/article6_datasafe_step_by_Step_Screenshot-2026-06-24-202030-4.png","width":1311,"height":724},{"@type":"BreadcrumbList","@id":"https:\/\/blog.agdba.de\/?p=321#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Start","item":"https:\/\/blog.agdba.de\/"},{"@type":"ListItem","position":2,"name":"Step-by-Step Guide: SQL Firewall in OCI Datasafe konfigurieren"}]},{"@type":"WebSite","@id":"https:\/\/blog.agdba.de\/#website","url":"https:\/\/blog.agdba.de\/","name":"agdba.de","description":"Oracle Database, OCI and more","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/blog.agdba.de\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"de"},{"@type":"Person","@id":"https:\/\/blog.agdba.de\/#\/schema\/person\/c9b8806180cd864945b5950d3dec5798","name":"Alexander Giesbrecht","image":{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/secure.gravatar.com\/avatar\/b0f7a24a2ab62199afeb3704ba03108c4a0b796d431d9342635095c0d1861e3b?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/b0f7a24a2ab62199afeb3704ba03108c4a0b796d431d9342635095c0d1861e3b?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/b0f7a24a2ab62199afeb3704ba03108c4a0b796d431d9342635095c0d1861e3b?s=96&d=mm&r=g","caption":"Alexander Giesbrecht"},"url":"https:\/\/blog.agdba.de\/?author=2"}]}},"_links":{"self":[{"href":"https:\/\/blog.agdba.de\/index.php?rest_route=\/wp\/v2\/posts\/321","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.agdba.de\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.agdba.de\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.agdba.de\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.agdba.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=321"}],"version-history":[{"count":10,"href":"https:\/\/blog.agdba.de\/index.php?rest_route=\/wp\/v2\/posts\/321\/revisions"}],"predecessor-version":[{"id":359,"href":"https:\/\/blog.agdba.de\/index.php?rest_route=\/wp\/v2\/posts\/321\/revisions\/359"}],"wp:attachment":[{"href":"https:\/\/blog.agdba.de\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=321"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.agdba.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=321"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.agdba.de\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=321"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}