REDACTION_COLUMNS

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

Parameters when the redaction type is partial

regexp_pattern

text

Pattern string when the redaction type is regexp

regexp_replace_string

text

Replacement string when the redaction type is regexp

regexp_position

integer

Specifies the start replacement position when the redaction type is regexp

regexp_occurrence

integer

The number of replacements when the redaction type is regexp

regexp_match_parameter

text

Regular control parameter when the redaction type is regexp

column_description

text

Description of the redacted column