{"id":28364,"date":"2023-09-27T20:39:35","date_gmt":"2023-09-27T18:39:35","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/?p=28364"},"modified":"2023-09-27T20:39:35","modified_gmt":"2023-09-27T18:39:35","slug":"sql-firewall","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/sql-firewall\/","title":{"rendered":"SQL FIREWALL"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">This blog comes to complete <a href=\"https:\/\/www.dbi-services.com\/blog\/oracle-sql-firewall-with-oracle-23c\/\">the excellent blog written by my colleague Gregory Steulet on the same topic.<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">SQL FIREWALL is a new security layer integrated into Oracle Database 23c.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">First, we create a admin user for which we grant it a new admin privilege &#8220;sql_firewall_admin&#8221;:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SQL&gt; drop user if exists lfeadmin cascade;\n\nUser dropped.\n\nSQL&gt;\nSQL&gt; create user lfeadmin identified by lfeadmin;\n\nUser created.\n\nSQL&gt; grant create session to lfeadmin;\n\nGrant succeeded.\n\nSQL&gt; grant sql_firewall_admin to lfeadmin;\n\nGrant succeeded.<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">We enable the SQL FIREWALL:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SQL&gt; prompt ENABLE SQL FIREWALL\nENABLE SQL FIREWALL\nSQL&gt; pause\n\nSQL&gt; conn lfeadmin\/lfeadmin@\/\/localhost:1521\/freepdb1\nConnected.\nSQL&gt; exec dbms_sql_firewall.enable;\n\nPL\/SQL procedure successfully completed.\n\nSQL&gt;\nSQL&gt; prompt CHECK THE STATUS OF SQL FIREWALL\nCHECK THE STATUS OF SQL FIREWALL\nSQL&gt; pause\n\nSQL&gt; select status from dba_sql_firewall_status;\n\nSTATUS\n--------\nENABLED<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">We create a capture process on the user LFE:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SQL&gt; prompt CREATE CAPTURE FOR USER LFE\nCREATE CAPTURE FOR USER LFE\nSQL&gt; pause\n\nSQL&gt; begin\n  2    dbms_sql_firewall.create_capture (\n  3  \t username\t=&gt; 'LFE',\n  4  \t top_level_only =&gt; false,\n  5  \t start_capture\t=&gt; true);\n  6  end;\n  7  \/\n\nPL\/SQL procedure successfully completed.\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">We execute some sql from the user LFE:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SQL&gt; conn LFE\/LFE4DBIXCHANGE2023@\/\/localhost:1521\/freepdb1\nConnected.\nSQL&gt; start demo_sql_firewall_load.sql\nSQL&gt; set echo on\nSQL&gt; set linesize 2000\nSQL&gt; prompt SESSION 1 - GET SID\nSESSION 1 - GET SID\nSQL&gt; pause\n\nSQL&gt; SELECT SYS_CONTEXT ('USERENV', 'SID') FROM DUAL;\n\nSYS_CONTEXT('USERENV','SID')\n----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------\n44\n\nSQL&gt; prompt SESSION 1 - UPDATE PRICE FOR PRODUCT A1 --&gt; PRICE = PRICE+10\nSESSION 1 - UPDATE PRICE FOR PRODUCT A1 --&gt; PRICE = PRICE+10\nSQL&gt; pause\n\nSQL&gt; select price from products where product='A1';\n\n     PRICE\n----------\n      1629\n\nSQL&gt; update products set price = price+10 where product= 'A1';\n\n1 row updated.\n\nSQL&gt; select price from products where product='A1';\n\n     PRICE\n----------\n      1629\n\nSQL&gt;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">We stop the capture and we check the capture logs:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SQL&gt; prompt STOP THE CAPTURE\nSTOP THE CAPTURE\nSQL&gt; pause\n\nSQL&gt; exec dbms_sql_firewall.stop_capture('LFE');\n\nPL\/SQL procedure successfully completed.\n\nSQL&gt;\nSQL&gt; prompt CHECK CAPTURE LOGS\nCHECK CAPTURE LOGS\nSQL&gt; pause\n\nSQL&gt; set linesize 150 pagesize 40\nSQL&gt; column command_type format a12\nSQL&gt; column current_user format a15\nSQL&gt; column client_program format a45\nSQL&gt; column os_user format a10\nSQL&gt; column ip_address format a10\nSQL&gt; column sql_text format a30\nSQL&gt;\nSQL&gt; select command_type,\n  2  \t    current_user,\n  3  \t    client_program,\n  4  \t    os_user,\n  5  \t    ip_address,\n  6  \t    sql_text\n  7  from   dba_sql_firewall_capture_logs\n  8  where  username = 'LFE';\n\nCOMMAND_TYPE CURRENT_USER CLIENT_PROGRAM OS_USER    IP_ADDRESS SQL_TEXT\n------------ --------------- --------------------------------------------- --\nSELECT\t     LFE\t     sqlplus@db23c (TNS V1-V3) oracle     127.0.0.1  SELECT SYS_CONTEXT (:\"SYS_B_0\",:\"SYS_B_1\") FROM DUAL\n\nSELECT\t     LFE\t     sqlplus@db23c (TNS V1-V3) oracle     127.0.0.1  SELECT PRICE FROM PRODUCTS WHERE PRODUCT=:\"SYS_B_0\"\n\nUPDATE\t     LFE\t     sqlplus@db23c (TNS V1-V3) oracle     127.0.0.1  UPDATE PRODUCTS SET PRICE=PRICE +:\"SYS_B_0\" WHERE PRODUCT=:\"SYS_B_1\"\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Now we generate an allow list based on the capture logs:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SQL&gt; exec dbms_sql_firewall.generate_allow_list ('LFE');\n\nPL\/SQL procedure successfully completed.\n\nSQL&gt;\nSQL&gt; prompt CHECK THE ALLOW LIST AND NEW DATA DICTIONARY VIEWS\nCHECK THE ALLOW LIST AND NEW DATA DICTIONARY VIEWS\nSQL&gt; pause\n\nSQL&gt; column username format a20\nSQL&gt; select * from  dba_sql_firewall_allowed_ip_addr where username = 'LFE';\n\nUSERNAME\t     IP_ADDRESS\n-------------------- ----------\nLFE\t\t     127.0.0.1\n\nSQL&gt;\nSQL&gt; column os_program format a50\nSQL&gt; select * from dba_sql_firewall_allowed_os_prog where username = 'LFE';\n\nUSERNAME\t     OS_PROGRAM\n-------------------- --------------------------------------------------\nLFE\t\t     sqlplus@db23c (TNS V1-V3)\n\nSQL&gt;\nSQL&gt; column os_user format a10\nSQL&gt; select * from dba_sql_firewall_allowed_os_user where username = 'LFE';\n\nUSERNAME\t     OS_USER\n-------------------- ----------\nLFE\t\t     oracle\n\nSQL&gt;\nSQL&gt; column sql_text format A50\nSQL&gt; select current_user,sql_text from dba_sql_firewall_allowed_sql where username = 'LFE';\n\nCURRENT_USER\tSQL_TEXT\n--------------- --------------------------------------------------\nLFE\t\tUPDATE PRODUCTS SET PRICE=PRICE +:\"SYS_B_0\" WHERE\n\t\tPRODUCT=:\"SYS_B_1\"\n\nLFE\t\tSELECT PRICE FROM PRODUCTS WHERE PRODUCT=:\"SYS_B_0\n\t\t\"\n\nLFE\t\tSELECT SYS_CONTEXT (:\"SYS_B_0\",:\"SYS_B_1\") FROM DU\n\t\tAL\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">The allow list stores the sql statement captures plus his context (IP ADDRESS, OS_PROGRAM, OS_USER).<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">We check this allow list and decides which sql statement \/ context authorized or un-authorized to be executed and we enable the allow list, we use the option &#8220;dbms_sql_firewall.enforfe_all&#8221; to authorize all : the sql statement plus the context. There are <a href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/23\/arpls\/dbms_sql_firewall.html#GUID-EE09A1FF-B48E-4CF3-BFB0-39992F96FF92\">different list of options<\/a>.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SQL&gt; begin\n  2    dbms_sql_firewall.enable_allow_list (\n  3  \t username =&gt; 'LFE',\n  4  \t enforce  =&gt; dbms_sql_firewall.enforce_all,\n  5  \t block\t  =&gt; true);\n  6  end;\n  7  \/\n\nPL\/SQL procedure successfully completed.\n\nSQL&gt; select username,\n    \t    status,\n    \t    top_level_only,\n    \t    enforce,\n    \t    block\n    from   dba_sql_firewall_allow_lists\n    where username='LFE';\n\nUSERNAME\t     STATUS   TOP_LEVEL_ONLY ENFORCE\t     BLOCK\n-------------------- -------- -------------- --------------- --------------\nLFE\t\t     ENABLED  N \t     ENFORCE_ALL     Y<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"> Now, SQL which are in the allow list are authorized:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SQL&gt; select price from products where product='A1';\n\n     PRICE\n----------\n      1629\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">But SQL which are not in the allow list are un-authorized:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SQL&gt; select price,product from products where product='A1';\nselect price,product from products where product='A1'\n                          *\nERROR at line 1:\nORA-47605: SQL Firewall violation<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">We check the sql firewall violation log table:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>select sql_text,\n           firewall_action,\n           ip_address,\n           cause,\n           occurred_at\n    from   dba_sql_firewall_violations\n    where  username = 'LFE';\n\nSQL_TEXT\n--------------------------------------------------------------------------------\nFIREWAL IP_ADDRESS\t\t\t\t\t CAUSE\n------- ------------------------------------------------ --------------------\nOCCURRED_AT\n---------------------------------------------------------------------------\nSELECT PRICE,PRODUCT FROM PRODUCTS WHERE PRODUCT=:\"SYS_B_0\"\nBlocked 127.0.0.1\t\t\t\t\t SQL violation\n27-SEP-23 06.30.31.875532 PM +00:00\n\n\nSQL&gt;<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>This blog comes to complete the excellent blog written by my colleague Gregory Steulet on the same topic. SQL FIREWALL is a new security layer integrated into Oracle Database 23c. First, we create a admin user for which we grant it a new admin privilege &#8220;sql_firewall_admin&#8221;: We enable the SQL FIREWALL: We create a capture&hellip;&nbsp;<\/p>\n","protected":false},"author":27,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"neve_meta_sidebar":"","neve_meta_container":"","neve_meta_enable_content_width":"","neve_meta_content_width":0,"neve_meta_title_alignment":"","neve_meta_author_avatar":"","neve_post_elements_order":"","neve_meta_disable_header":"","neve_meta_disable_footer":"","neve_meta_disable_title":"","neve_meta_reading_time":"","_themeisle_gutenberg_block_has_review":false,"footnotes":""},"categories":[4133,59],"tags":[1672,6416,25],"class_list":["post-28364","post","type-post","status-publish","format-standard","category-database","category-oracle","tag-new-features","tag-oracle-23c","tag-security"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v28.8 (Yoast SEO v28.9) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>SQL FIREWALL - dbi services Blog<\/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:\/\/www.dbi-services.com\/blog\/sql-firewall\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL FIREWALL\" \/>\n<meta property=\"og:description\" content=\"This blog comes to complete the excellent blog written by my colleague Gregory Steulet on the same topic. SQL FIREWALL is a new security layer integrated into Oracle Database 23c. First, we create a admin user for which we grant it a new admin privilege &#8220;sql_firewall_admin&#8221;: We enable the SQL FIREWALL: We create a capture&hellip;&nbsp;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/sql-firewall\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi services Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/dbiservices\/\" \/>\n<meta property=\"article:published_time\" content=\"2023-09-27T18:39:35+00:00\" \/>\n<meta name=\"author\" content=\"Oracle Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@dbiservices\" \/>\n<meta name=\"twitter:site\" content=\"@dbiservices\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Oracle Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-firewall\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-firewall\\\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/bf7c7eb0bec165183207237c9d0ee1d5\"},\"headline\":\"SQL FIREWALL\",\"datePublished\":\"2023-09-27T18:39:35+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-firewall\\\/\"},\"wordCount\":186,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/#organization\"},\"keywords\":[\"New Features\",\"Oracle 23c\",\"Security\"],\"articleSection\":[\"Database\",\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-firewall\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-firewall\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-firewall\\\/\",\"name\":\"SQL FIREWALL - dbi services Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"datePublished\":\"2023-09-27T18:39:35+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-firewall\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-firewall\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-firewall\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL FIREWALL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"name\":\"dbi services Blog\",\"description\":\"#BeSharing\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/#organization\",\"name\":\"dbi services\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/dbi-services-logo.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/dbi-services-logo.png\",\"width\":512,\"height\":512,\"caption\":\"dbi services\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/dbiservices\\\/\",\"https:\\\/\\\/x.com\\\/dbiservices\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/dbi-services\\\/\",\"https:\\\/\\\/www.youtube.com\\\/user\\\/dbiservices\"],\"description\":\"Swiss IT consulting and services company specialized in efficient data infrastructures and platforms: databases, application servers, cloud, DevOps, digitalization, analytics, data quality and monitoring. Headquartered in Del\u00e9mont with offices in Nyon, Basel, Bern and Zurich.\",\"email\":\"info@dbi-services.com\",\"telephone\":\"+41 32 422 96 00\",\"legalName\":\"dbi services SA\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/bf7c7eb0bec165183207237c9d0ee1d5\",\"name\":\"Oracle Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/12\\\/oracle-square.png\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/12\\\/oracle-square.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/12\\\/oracle-square.png\",\"caption\":\"Oracle Team\"},\"description\":\"Posts published under the Oracle Team account are collective contributions by the dbi services Oracle consultants. The practice covers the full Oracle Database lifecycle: architecture, migration and upgrade, high availability with RAC and Data Guard, backup and recovery, performance tuning, and engineered systems such as Oracle Database Appliance and Exadata. The team holds Oracle certifications up to Certified Master level and operates customer platforms under service level agreements.\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/oracle-team\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"SQL FIREWALL - dbi services Blog","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:\/\/www.dbi-services.com\/blog\/sql-firewall\/","og_locale":"en_US","og_type":"article","og_title":"SQL FIREWALL","og_description":"This blog comes to complete the excellent blog written by my colleague Gregory Steulet on the same topic. SQL FIREWALL is a new security layer integrated into Oracle Database 23c. First, we create a admin user for which we grant it a new admin privilege &#8220;sql_firewall_admin&#8221;: We enable the SQL FIREWALL: We create a capture&hellip;&nbsp;","og_url":"https:\/\/www.dbi-services.com\/blog\/sql-firewall\/","og_site_name":"dbi services Blog","article_publisher":"https:\/\/www.facebook.com\/dbiservices\/","article_published_time":"2023-09-27T18:39:35+00:00","author":"Oracle Team","twitter_card":"summary_large_image","twitter_creator":"@dbiservices","twitter_site":"@dbiservices","twitter_misc":{"Written by":"Oracle Team","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/sql-firewall\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-firewall\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bf7c7eb0bec165183207237c9d0ee1d5"},"headline":"SQL FIREWALL","datePublished":"2023-09-27T18:39:35+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-firewall\/"},"wordCount":186,"commentCount":0,"publisher":{"@id":"https:\/\/www.dbi-services.com\/#organization"},"keywords":["New Features","Oracle 23c","Security"],"articleSection":["Database","Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/sql-firewall\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/sql-firewall\/","url":"https:\/\/www.dbi-services.com\/blog\/sql-firewall\/","name":"SQL FIREWALL - dbi services Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2023-09-27T18:39:35+00:00","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-firewall\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/sql-firewall\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/sql-firewall\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL FIREWALL"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi services Blog","description":"#BeSharing","publisher":{"@id":"https:\/\/www.dbi-services.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.dbi-services.com\/#organization","name":"dbi services","url":"https:\/\/www.dbi-services.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/09\/dbi-services-logo.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/09\/dbi-services-logo.png","width":512,"height":512,"caption":"dbi services"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/dbiservices\/","https:\/\/x.com\/dbiservices","https:\/\/www.linkedin.com\/company\/dbi-services\/","https:\/\/www.youtube.com\/user\/dbiservices"],"description":"Swiss IT consulting and services company specialized in efficient data infrastructures and platforms: databases, application servers, cloud, DevOps, digitalization, analytics, data quality and monitoring. Headquartered in Del\u00e9mont with offices in Nyon, Basel, Bern and Zurich.","email":"info@dbi-services.com","telephone":"+41 32 422 96 00","legalName":"dbi services SA"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bf7c7eb0bec165183207237c9d0ee1d5","name":"Oracle Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/12\/oracle-square.png","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/12\/oracle-square.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/12\/oracle-square.png","caption":"Oracle Team"},"description":"Posts published under the Oracle Team account are collective contributions by the dbi services Oracle consultants. The practice covers the full Oracle Database lifecycle: architecture, migration and upgrade, high availability with RAC and Data Guard, backup and recovery, performance tuning, and engineered systems such as Oracle Database Appliance and Exadata. The team holds Oracle certifications up to Certified Master level and operates customer platforms under service level agreements.","url":"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/28364","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/27"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=28364"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/28364\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=28364"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=28364"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=28364"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}