Table of Contents Previous Next


3 Built-In Packages : 3.13 DBMS_REDACT : 3.13.5 ENABLE_POLICY

The enable_policy procedure enables the previously disabled data redaction policy.
object_schema IN VARCHAR2 DEFAULT NULL,
object_name IN VARCHAR2,
policy_name IN VARCHAR2
The drop_policy procedure drops a data redaction policy by removing the masking policy from a table.
object_schema IN VARCHAR2 DEFAULT NULL,
object_name IN VARCHAR2,
policy_name IN VARCHAR2
The update_full_redaction_values procedure updates the default displayed values for a data redaction policy and these default values can be viewed using the redaction_values_for_type_full view that use the full redaction type.
number_val IN NUMBER DEFAULT NULL,
binfloat_val IN FLOAT4 DEFAULT NULL,
bindouble_val IN FLOAT8 DEFAULT NULL,
char_val IN CHAR DEFAULT NULL,
varchar_val IN VARCHAR2 DEFAULT NULL,
nchar_val IN NCHAR DEFAULT NULL,
nvarchar_val IN NVARCHAR2 DEFAULT NULL,
datecol_val IN DATE DEFAULT NULL,
ts_val IN TIMESTAMP DEFAULT NULL,
tswtz_val IN TIMESTAMPTZ DEFAULT NULL,
blob_val IN BLOB DEFAULT NULL,
clob_val IN CLOB DEFAULT NULL,
nclob_val IN CLOB DEFAULT NULL
The FLOAT4 datatype is a random value. The binary float datatype is not supported.
The FLOAT8 datatype is a random value. The binary double datatype is not supported.
The nchar_val is mapped to CHAR datatype and returns the CHAR value.
The nvarchar_val is mapped to VARCHAR2 datatype and returns the VARCHAR value.
The nclob_val is mapped to CLOB datatype and returns the CLOB value.
1. View the default values using redaction_values_for_type_full view as shown below:
3. You can now see the updated values using redaction_values_for_type_full view.

3 Built-In Packages : 3.13 DBMS_REDACT : 3.13.5 ENABLE_POLICY

Table of Contents Previous Next