Top
Enterprise Postgres 17 Security Operation Guide

A.6 pgx_confidential_role

A list of roles registered in the confidentiality group.

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

Column name

Type

Constraint

Description

crolid

bigint

primary key
generated always as identity

Identifier of the role.

crolmatid

bigint

not null
references pgx_confidential_matrix(cmatid)

Identifier of the confidentiality matrix to which the role belongs.

crolgroid

bigint

not null
references pgx_confidential_group(cgroid)

Identifier of the confidentiality group to which the role belongs.

crolname

name

not null

Name of the role.

crolupdate

timestamp with time zone

not null

Registration time of the role.