Table of Contents Previous Next


3 Built-In Packages : 3.13 DBMS_REDACT : 3.13.3 ALTER_POLICY

The alter_policy procedure alters or modifies an existing data redaction policy for a table.
object_schema IN VARCHAR2 DEFAULT NULL,
object_name IN VARCHAR2,
policy_name IN VARCHAR2,
action IN INTEGER DEFAULT DBMS_REDACT.ADD_COLUMN,
column_name IN VARCHAR2 DEFAULT NULL,
function_type IN INTEGER DEFAULT DBMS_REDACT.FULL,
function_parameters IN VARCHAR2 DEFAULT NULL,
expression IN VARCHAR2 DEFAULT NULL,
regexp_pattern IN VARCHAR2 DEFAULT NULL,
regexp_replace_string IN VARCHAR2 DEFAULT NULL,
regexp_position IN INTEGER DEFAULT DBMS_REDACT.RE_BEGINNING,
regexp_occurrence IN INTEGER DEFAULT DBMS_REDACT.RE_ALL,
regexp_match_parameter IN VARCHAR2 DEFAULT NULL,
policy_description IN VARCHAR2 DEFAULT NULL,
column_description IN VARCHAR2 DEFAULT NULL,
custom_function_expression IN VARCHAR2 DEFAULT NULL
The action to perform. For more information about action parameters see, Using DBMS_REDACT Constants and Function Parameters.
The type of redaction function to be used. The possible values are NONE, FULL, PARTIAL, RANDOM, REGEXP, and CUSTOM.
Enables the use of regular expressions to redact data. If the regexp_pattern does not match the data, then the NULL value is returned.
Specifies the replacement occurrence of a substring. If the constant is RE_ALL, then the replacement of each matching substring occurs. If the constant is RE_FIRST, then the replacement of the first matching substring occurs.
Changes the default matching behavior of a function. The possible regexp_match_parameter constants can be ‘RE_CASE_SENSITIVE’, ‘RE_CASE_INSENSITIVE’, ‘RE_MULTIPLE_LINES’, ‘RE_NEWLINE_WILDCARD’, ‘RE_IGNORE_WHITESPACE’.
Note: For more information on constants, function_parameters, or regexp (regular expressions) see, Using DBMS_REDACT Constants and Function Parameters.
Description of the column to be redacted. The column_description is not supported, but if you specify the description for a column then, you will get a warning message.
The custom_function_expression is applicable only for the CUSTOM redaction type. The custom_function_expression is a function expression that is, schema-qualified function with a parameter such as schema_name.function_name (argument1, …)that allows a user to use their redaction logic to redact the column data.
The following example illustrates to alter a policy using partial redaction for values in the payment_details_tab table card_string (usually a credit card number) column.
The disable_policy procedure disables an existing data redaction policy.
object_schema IN VARCHAR2 DEFAULT NULL,
object_name IN VARCHAR2,
policy_name IN VARCHAR2

3 Built-In Packages : 3.13 DBMS_REDACT : 3.13.3 ALTER_POLICY

Table of Contents Previous Next