Help Center> Data Warehouse Service> SQL Syntax Reference> Functions and Operators> Data Redaction Functions> Modifying a Redact Policy
View PDF

Modifying a Redact Policy

Modify a created redact policy, for example, add columns to be redacted to a table policy, delete the columns to be redacted, modify the expression, and modify the column redaction type. The following function interfaces are provided:

DBMS_REDACT.ALTER_POLICY(
object_schema           IN  name,
object_name             IN  name,
policy_name             IN  name,
action                   IN  int2  default  1 ,
column_name            IN  name  default  NULL,
function_type            IN  int2  default  1,
function_parameters      IN  Text  default  NULL,
expression              IN  Text  default  NULL,
regexp_pattern          IN  Text  default  NULL,
regexp_replace_string    IN  Text  default  NULL,
regexp_position         IN  int4   default  1,
regexp_occurrence       IN  int4   defalut  0,
regexp_match_parameter  IN  Text  default  NULL,
policy_description       IN  Text  default  NULL,
column_description      IN  Text  default  NULL
)

Except the action parameter, other interfaces are the same as those in ADD_POLICY.

  • action: specifies the action of ALTER_POLICY. The value of ALTER_POLICY ranges from 1 to 6. The meanings are as follows:
    1. ADD_COLUMN: adds a column to a policy. function_type must be specified.
    2. DROP_COLUMN: deletes a column from a policy.
    3. MODIFY_EXPRESSION: modifies the policy judgment expression.
    4. MODIFY_COLUMN: Modifies function_type or function_parameters of the redacted column.
    5. SET_POLICY_DESCRIPTION: sets the policy description.
    6. SET_COLUMN_DESCRIPTION: sets the description of the redacted column.
Parent topic: Data Redaction Functions