Updated on 2025-10-10 GMT+08:00

REDACTION_POLICIES

REDACTION_POLICIES displays information about all redaction objects in the current database.

Table 1 REDACTION_POLICIES columns

Name

Type

Description

object_schema

name

Redacted object schema.

object_owner

name

Redacted object owner.

object_name

name

Redacted object name.

policy_name

name

Name of the redaction policy.

expression

text

Policy effective expression (for users).

enable

boolean

Policy status (enabled or disabled).

policy_description

text

Policy description.

inherited

bool

Whether a redacted column is inherited from another redacted column.