Differences

This shows you the differences between two versions of the page.

--- dataredaction [2015/07/23 13:19] – created z0hpvk
+++ dataredaction [2025/03/08 22:24] (current) – external edit 127.0.0.1
@@ Line 1: / Line 1: @@
 ===== Data Redaction =====
 Uses the DBMS_REDACT package.\\
+The following procedures can be used ...
+  * ADD_POLICY
+  * ALTER_POLICY
+  * DISABLE_POLICY
+  * DROP_POLICY
+  * ENABLE_POLICY
 The following Function Types are available ...
   * DBMS_REDACT.NONE
@@ Line 6: / Line 13: @@
   * DBMS_REDACT.PARTIAL (Number, Character, Date)
   * DBMS_REDACT.RANDOM
+The below examples fully redacts all details in the card_no column.
+<code>BEGIN
+  DBMS_REDACT.add_policy(
+    object_schema => 'c##ian',
+    object_name   => 'payment_details',
+    column_name   => 'card_no',
+    policy_name   => 'redact_card_info',
+    function_type => DBMS_REDACT.full,
+    expression    => '1=1'
+  );
+END;</code>
+There is a EXEMPT REDACTION POLICY privilege.\\
+CTAS commands against a redacted table will fail.\\
+Redaction does not apply to the WHERE clause.\\
+[[https://oracle-base.com/articles/12c/data-redaction-12cr1|Oracle Base Article]]