Updated on 2023-10-23 GMT+08:00

GS_MASKING_POLICY_FILTERS

GS_MASKING_POLICY_FILTERS records the user filter criteria corresponding to the dynamic data masking policies. The corresponding masking policy takes effect only when the user information meets the filter criteria. Only the system administrator or security policy administrator can access this system catalog.

Table 1 GS_MASKING_POLICY_FILTERS columns

Name

Type

Description

oid

oid

Row identifier (hidden attribute, which must be specified).

filtertype

name

Filter type. Currently, the value is logical_expr.

filterlabelname

name

Filter range. Currently, the value is logical_expr.

policyoid

oid

OID of the masking policy to which a user filter criterion belongs, which corresponds to the OID in GS_MASKING_POLICY

modifydate

timestamp without time zone

Latest timestamp when a user filter criterion is created or modified

logicaloperator

text

Polish notation of a filter criterion