Help Center/GaussDB/Developer Guide(Centralized_V2.0-2.x)/System Catalogs and System Views/System Views/PG_RLSPOLICIES
Updated on 2025-08-19 GMT+08:00
View PDF

PG_RLSPOLICIES

PG_RLSPOLICIES displays information about row-level security policies. The initial user and users with the SYSADMIN attribute can view all policy information. Other users can view only the policy information in their own tables.

Table 1 PG_RLSPOLICIES columns

Name

Type

Description

schemaname

name

Name of the schema of the table object to which a row-level security policy is applied.

tablename

name

Name of the table object to which the row-level security policy is applied.

policyname

name

Name of a row-level security policy.

policypermissive

text

Expression concatenation mode of a row-level security policy. Value range:

  • PERMISSIVE: permissive policy, which is concatenated using the OR expression.
  • RESTRICTIVE: restrictive policy, which is concatenated using the AND expression.

policyroles

name[]

List of users affected by the row-level security policy. If this parameter is not specified, all users are affected.

policycmd

text

SQL operations affected by a row-level security policy.

policyqual

text

Expression of a row-level security policy.

Parent topic:System Views