Help Center> GaussDB> Distributed_3.x> System Catalogs and System Views> System Catalogs> PG_RLSPOLICY
Updated on 2024-05-07 GMT+08:00
View PDF

PG_RLSPOLICY

PG_RLSPOLICY records row-level access control policies.

Table 1 PG_RLSPOLICY columns

Name

Type

Description

oid

oid

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

polname

name

Name of an access control policy.

polrelid

oid

OID of the table object on which the row-level access control policy takes effect.

polcmd

"char"

SQL operations affected by the row-level access control policy.

polpermissive

Boolean

Attribute of the row-level security policy.

  • t: OR condition concatenation of expressions.
  • f: AND condition concatenation of expressions.

polroles

oid[]

OID list of users affected by the row-level access control policy. If this parameter is not specified, all users are affected.

polqual

pg_node_tree

Expression of the row-level access control policy.
Parent topic: System Catalogs