{"id":54359,"date":"2023-04-17T21:15:57","date_gmt":"2023-04-17T21:15:57","guid":{"rendered":"https:\/\/dbtut.com\/?p=54359"},"modified":"2023-04-17T21:20:05","modified_gmt":"2023-04-17T21:20:05","slug":"virtual-private-database-in-oracle","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2023\/04\/17\/virtual-private-database-in-oracle\/","title":{"rendered":"Virtual Private Database In Oracle"},"content":{"rendered":"<p>In today&#8217;s article, I will introduce the &#8220;Virtual Private Database&#8221; feature, which is one of the security policies offered by Oracle.<\/p>\n<p>With Virtual Private Database, you can hide data on a row and column basis for users determined by different security policies, and also impose restrictions on commands such as insert, update and delete.<\/p>\n<p>Thanks to this feature, which solves our business quickly on the basis of users, you can also create solutions on KVKK relatively.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/www.cozumpark.com\/wp-content\/uploads\/2020\/02\/0.jpg\" \/><\/p>\n<p>To create the Oracle Virtual Private rule structure, we will first need a function.<\/p>\n<p>In our scenario, I will use the incoming HR schema on Oracle Database for testing purposes. Our function will be named POL_MAAS_GIZLE.<\/p>\n<pre class=\"lang:default decode:true \">CREATE OR REPLACE FUNCTION SYSTEM.POL_MAAS_GIZLE (v_SchemaName   IN VARCHAR2,\r\n                                                  v_ObjectName   IN VARCHAR2)\r\n    RETURN VARCHAR2\r\nAS\r\n    condition   VARCHAR2 (200);\r\nBEGIN\r\n    condition := 'JOB_ID = ''AD_VP123''';\r\n    RETURN (condition);\r\nEND POL_MAAS_GIZLE;\r\n\/<\/pre>\n<p>Our function has been created successfully. Let&#8217;s check.<\/p>\n<pre class=\"lang:default decode:true \">SELECT * FROM DBA_POLICIES WHERE POLICY_NAME='POL_MAAS_GIZLE';<\/pre>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/www.cozumpark.com\/wp-content\/uploads\/2020\/02\/Screenshot_1.jpg\" \/><\/p>\n<p>Now we create our rule. In our rule, we will hide the &#8220;MAAS&#8221; (SALARY) column in the EMPLOYESS table in the HR schema.<\/p>\n<p>When the query runs, it will return a NULL value. Since this value returns INTEGER, we cannot replace it with anything else.<\/p>\n<pre class=\"lang:default decode:true \">BEGIN\r\n    DBMS_RLS.ADD_POLICY (object_schema       =&gt; 'HR',\r\n                         object_name         =&gt; 'EMPLOYEES',\r\n                         policy_name         =&gt; 'POL_MAAS_GIZLE',\r\n                         function_schema     =&gt; 'SYSTEM',\r\n                         policy_function     =&gt; 'POL_MAAS_GIZLE',\r\n                         statement_types     =&gt; 'SELECT',\r\n                         policy_type         =&gt; DBMS_RLS.SHARED_STATIC,\r\n                         sec_relevant_cols       =&gt; 'SALARY',\r\n                         sec_relevant_cols_opt   =&gt; DBMS_RLS.ALL_ROWS);\r\n\r\nEND;\r\n\/<\/pre>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/www.cozumpark.com\/wp-content\/uploads\/2020\/02\/Screenshot_2-2.jpg\" \/><\/p>\n<p>When you create a rule for Oracle Virtual Private database, it affects all users created for the system, such as SYS and SYSTEM.<\/p>\n<p>If there is a user that you do not want to be stuck in the VPD rule, you need to specify it with GRANT.<\/p>\n<pre class=\"lang:default decode:true \">-- To exclude a user from VPD\r\nSQL\\&gt; GRANT EXEMPT ACCESS POLICY TO USR_ABUZER;<\/pre>\n<p>We are selecting again. As you can see, the salary column has appeared.<img decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/www.cozumpark.com\/wp-content\/uploads\/2020\/02\/Screenshot_3.jpg\" \/><\/p>\n<p>If we want it to appear again,<\/p>\n<pre class=\"lang:default decode:true \">REVOKE EXEMPT ACCESS POLICY FROM USR_ABUZER;\r\n<\/pre>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/www.cozumpark.com\/wp-content\/uploads\/2020\/02\/Screenshot_2-1.jpg\" \/><\/p>\n<p>If you want to extend the constraint, you can extend it by putting &#8220;,&#8221; in the schema, table and query.<\/p>\n<p>For example, the &#8220;EMAIL&#8221; part should not appear. For this, you need to add to the \u201d sec_relevant_cols_opt \u201d field.<\/p>\n<pre class=\"lang:default decode:true \">BEGIN\r\n    DBMS_RLS.ADD_POLICY (object_schema       =&gt; 'HR',\r\n                         object_name         =&gt; 'EMPLOYEES',\r\n                         policy_name         =&gt; 'POL_MAAS_GIZLE',\r\n                         function_schema     =&gt; 'SYSTEM',\r\n                         policy_function     =&gt; 'POL_MAAS_GIZLE',\r\n                         statement_types     =&gt; 'SELECT',\r\n                         policy_type         =&gt; DBMS_RLS.SHARED_STATIC,\r\n                         sec_relevant_cols       =&gt; 'SALARY,EMAIL',\r\n                         sec_relevant_cols_opt   =&gt; DBMS_RLS.ALL_ROWS);\r\n\r\nEND;\r\n\/<\/pre>\n<p>We simply masked our data with the Oracle Virtual Private Database feature.<\/p>\n<p>So how can we delete a rule we wrote?<\/p>\n<pre class=\"lang:default decode:true \">BEGIN\r\n    DBMS_RLS.DROP_POLICY (object_schema   =&gt; 'HR',\r\n                          object_name     =&gt; 'EMPLOYEES',\r\n                          policy_name     =&gt; 'POL_MAAS_GIZLE');\r\nEND;\r\n\/<\/pre>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_54359\" class=\"pvc_stats all  \" data-element-id=\"54359\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>In today&#8217;s article, I will introduce the &#8220;Virtual Private Database&#8221; feature, which is one of the security policies offered by Oracle. With Virtual Private Database, you can hide data on a row and column basis for users determined by different security policies, and also impose restrictions on commands such as insert, update and delete. Thanks &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_54359\" class=\"pvc_stats all  \" data-element-id=\"54359\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":574,"featured_media":54365,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[4],"tags":[],"class_list":["post-54359","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-oracle"],"aioseo_notices":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Virtual Private Database In Oracle - Database Tutorials<\/title>\n<meta name=\"description\" content=\"In today&#039;s article, I will introduce the &quot;Virtual Private Database&quot; feature, which is one of the security policies offered by Oracle.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2023\/04\/17\/virtual-private-database-in-oracle\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Virtual Private Database In Oracle - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"In today&#039;s article, I will introduce the &quot;Virtual Private Database&quot; feature, which is one of the security policies offered by Oracle.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2023\/04\/17\/virtual-private-database-in-oracle\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-04-17T21:15:57+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-04-17T21:20:05+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/04\/Ekran-goruntusu-2023-04-18-001356.png\" \/>\n\t<meta property=\"og:image:width\" content=\"695\" \/>\n\t<meta property=\"og:image:height\" content=\"293\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Bu\u011fra PARLAYAN\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Bu\u011fra PARLAYAN\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/04\/17\/virtual-private-database-in-oracle\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/04\/17\/virtual-private-database-in-oracle\/\"},\"author\":{\"name\":\"Bu\u011fra PARLAYAN\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/f07abb2de370d35d6c93e90d8eb2b9f2\"},\"headline\":\"Virtual Private Database In Oracle\",\"datePublished\":\"2023-04-17T21:15:57+00:00\",\"dateModified\":\"2023-04-17T21:20:05+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/04\/17\/virtual-private-database-in-oracle\/\"},\"wordCount\":300,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/04\/17\/virtual-private-database-in-oracle\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/04\/Ekran-goruntusu-2023-04-18-001356.png\",\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2023\/04\/17\/virtual-private-database-in-oracle\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/04\/17\/virtual-private-database-in-oracle\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2023\/04\/17\/virtual-private-database-in-oracle\/\",\"name\":\"Virtual Private Database In Oracle - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/04\/17\/virtual-private-database-in-oracle\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/04\/17\/virtual-private-database-in-oracle\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/04\/Ekran-goruntusu-2023-04-18-001356.png\",\"datePublished\":\"2023-04-17T21:15:57+00:00\",\"dateModified\":\"2023-04-17T21:20:05+00:00\",\"description\":\"In today's article, I will introduce the \\\"Virtual Private Database\\\" feature, which is one of the security policies offered by Oracle.\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/04\/17\/virtual-private-database-in-oracle\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2023\/04\/17\/virtual-private-database-in-oracle\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/04\/17\/virtual-private-database-in-oracle\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/04\/Ekran-goruntusu-2023-04-18-001356.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/04\/Ekran-goruntusu-2023-04-18-001356.png\",\"width\":695,\"height\":293},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/04\/17\/virtual-private-database-in-oracle\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Virtual Private Database In Oracle\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/f07abb2de370d35d6c93e90d8eb2b9f2\",\"name\":\"Bu\u011fra PARLAYAN\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/8fe63334d745f00f79f9f47b870aa143dd0f7615580c741a3b078aa4d09fa071?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/8fe63334d745f00f79f9f47b870aa143dd0f7615580c741a3b078aa4d09fa071?s=96&d=mm&r=g\",\"caption\":\"Bu\u011fra PARLAYAN\"},\"description\":\"Burgra Parlayan is an experienced Database and Weblogic Administrator. After completing his technical \/ relevant training he has got involved with a serious amount of projects. He successfully managed database upgrade, database migration, database performance tuning projects for various public institutions.Currently he has been employed by one of the leading financial institutions called Turkiye Hayat &amp; Emeklilik as responsible administrator for Oracle Database and Oracle Middleware. He has been sharing his experience and knowledge by face to face training, personal blog and various social networking accounts to support the Oracle ecosystem continuously since 2010.\",\"sameAs\":[\"http:\/\/www.bugraparlayan.com.tr\/\"],\"url\":\"https:\/\/dbtut.com\/index.php\/author\/bugraparlayan\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Virtual Private Database In Oracle - Database Tutorials","description":"In today's article, I will introduce the \"Virtual Private Database\" feature, which is one of the security policies offered by Oracle.","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:\/\/dbtut.com\/index.php\/2023\/04\/17\/virtual-private-database-in-oracle\/","og_locale":"en_US","og_type":"article","og_title":"Virtual Private Database In Oracle - Database Tutorials","og_description":"In today's article, I will introduce the \"Virtual Private Database\" feature, which is one of the security policies offered by Oracle.","og_url":"https:\/\/dbtut.com\/index.php\/2023\/04\/17\/virtual-private-database-in-oracle\/","og_site_name":"Database Tutorials","article_published_time":"2023-04-17T21:15:57+00:00","article_modified_time":"2023-04-17T21:20:05+00:00","og_image":[{"width":695,"height":293,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/04\/Ekran-goruntusu-2023-04-18-001356.png","type":"image\/png"}],"author":"Bu\u011fra PARLAYAN","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Bu\u011fra PARLAYAN","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2023\/04\/17\/virtual-private-database-in-oracle\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/04\/17\/virtual-private-database-in-oracle\/"},"author":{"name":"Bu\u011fra PARLAYAN","@id":"https:\/\/dbtut.com\/#\/schema\/person\/f07abb2de370d35d6c93e90d8eb2b9f2"},"headline":"Virtual Private Database In Oracle","datePublished":"2023-04-17T21:15:57+00:00","dateModified":"2023-04-17T21:20:05+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/04\/17\/virtual-private-database-in-oracle\/"},"wordCount":300,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/04\/17\/virtual-private-database-in-oracle\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/04\/Ekran-goruntusu-2023-04-18-001356.png","articleSection":["ORACLE"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2023\/04\/17\/virtual-private-database-in-oracle\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2023\/04\/17\/virtual-private-database-in-oracle\/","url":"https:\/\/dbtut.com\/index.php\/2023\/04\/17\/virtual-private-database-in-oracle\/","name":"Virtual Private Database In Oracle - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/04\/17\/virtual-private-database-in-oracle\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/04\/17\/virtual-private-database-in-oracle\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/04\/Ekran-goruntusu-2023-04-18-001356.png","datePublished":"2023-04-17T21:15:57+00:00","dateModified":"2023-04-17T21:20:05+00:00","description":"In today's article, I will introduce the \"Virtual Private Database\" feature, which is one of the security policies offered by Oracle.","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/04\/17\/virtual-private-database-in-oracle\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2023\/04\/17\/virtual-private-database-in-oracle\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2023\/04\/17\/virtual-private-database-in-oracle\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/04\/Ekran-goruntusu-2023-04-18-001356.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/04\/Ekran-goruntusu-2023-04-18-001356.png","width":695,"height":293},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2023\/04\/17\/virtual-private-database-in-oracle\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"Virtual Private Database In Oracle"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/f07abb2de370d35d6c93e90d8eb2b9f2","name":"Bu\u011fra PARLAYAN","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/8fe63334d745f00f79f9f47b870aa143dd0f7615580c741a3b078aa4d09fa071?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/8fe63334d745f00f79f9f47b870aa143dd0f7615580c741a3b078aa4d09fa071?s=96&d=mm&r=g","caption":"Bu\u011fra PARLAYAN"},"description":"Burgra Parlayan is an experienced Database and Weblogic Administrator. After completing his technical \/ relevant training he has got involved with a serious amount of projects. He successfully managed database upgrade, database migration, database performance tuning projects for various public institutions.Currently he has been employed by one of the leading financial institutions called Turkiye Hayat &amp; Emeklilik as responsible administrator for Oracle Database and Oracle Middleware. He has been sharing his experience and knowledge by face to face training, personal blog and various social networking accounts to support the Oracle ecosystem continuously since 2010.","sameAs":["http:\/\/www.bugraparlayan.com.tr\/"],"url":"https:\/\/dbtut.com\/index.php\/author\/bugraparlayan\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/54359","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/574"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=54359"}],"version-history":[{"count":1,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/54359\/revisions"}],"predecessor-version":[{"id":54366,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/54359\/revisions\/54366"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/54365"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=54359"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=54359"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=54359"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}