Top
Enterprise Postgres 17 Security Operation Guide

A.7 pgx_confidential_policy

This is a list of policies created to set privileges for confidentiality objects of rowset type. You can refer to the name of the policy you created and the privileges it has set.

Rows in this table are inserted when you add a rowset type confidentiality object.

Column name

Type

Constraint

Description

cpolid

bigint

primary key
generated always as identity

Identifier of the policy.

cpolmatid

bigint

not null
references pgx_confidential_matrix(cmatid)

Identifier of the confidentiality matrix to which the policy belongs.

cpollevid

bigint

not null
references pgx_confidential_level(clevid)

Identifier of the confidentiality level to which the policy belongs.

cpolgroid

bigint

not null
references pgx_confidential_group(cgroid)

Identifier of the confidentiality group to which the policy belongs.

cpolobjid

bigint

not null
references pgx_confidential_object(cobjid)

Identifier of the rowset object using this policy.

cpolprivilege

text

not null

Privilege this policy has (SELECT, INSERT, UPDATE, DELETE, ALL).

cpolname

name

not null

Name of the policy.

cpolexpression

jsonb

not null

Expression of the policy.