REDACTION_COLUMNS

Updated on 2024-09-30 GMT+08:00

View PDF

REDACTION_COLUMNS displays information about all redaction columns in the current database.

**Table 1** **REDACTION_COLUMNS** columns
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.