Top
Enterprise Postgres 17 Security Operation Guide

A.5 pgx_confidential_object

A list of confidentiality objects.

You can refer to object attributes or update time, and so on.

Column name

Type

Constraint

Description

cobjid

bigint

primary key
generated always as identity

Identifier of the confidentiality object.

cobjmatid

bigint

not null
references pgx_confidential_matrix(cmatid)

Identifier of the confidentiality matrix to which the confidentiality object belongs.

cobjlevid

bigint

not null
references pgx_confidential_level(clevid)

Identifier of the confidentiality level to which the confidentiality object belongs.

cobjtype

text

not null

The type of confidentiality object.

cobjschema

name

not null

Schema name of the confidentiality object.

cobjtable

name

not null

Table name of the confidentiality object.

cobjname

text

not null

Name of the confidentiality object.

cobjupdate

timestamp with time zone

not null

Registration time of the confidentiality object.

cobjpolicy

jsonb

Conditions that determine the range of rowsets when the type is rowset.

It is expressed by the setting contents in POLICY.