REDACTION_COLUMNS¶
REDACTION_COLUMNS displays information about all redaction columns in the current database.
Name | Type | Description |
|---|---|---|
object_owner | Name | Owner of the object to be redacted. |
object_name | Name | Redacted object name. |
column_name | Name | Redacted column name. |
function_type | Integer | Redaction type. |
function_parameters | Text | Parameter used when the redaction type is partial (reserved). |
regexp_pattern | Text | Pattern string when the redaction type is regexp (reserved). |
regexp_replace_string | Text | Replacement string when the redaction type is regexp (reserved). |
regexp_position | Integer | Start and end replacement positions when the redaction type is regexp (reserved). |
regexp_occurrence | Integer | Replacement times when the redaction type is regexp (reserved). |
regexp_match_parameter | Text | Regular control parameter used when the redaction type is regexp (reserved). |
function_info | Text | Redaction function information. |
column_description | Text | Description of the redacted column. |
inherited | Bool | Whether a redacted column is inherited from another redacted column. |
policy_name | Name | Name of the data masking policy. This parameter is supported only by clusters of version 8.2.1.100 or later. |