Help Center > > Developer Guide> System Catalogs and System Views> System Views> REDACTION_COLUMNS

REDACTION_COLUMNS

Updated at: Dec 30, 2020 GMT+08:00

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

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel