A list of confidentiality groups.
You can refer to the registered confidentiality group attributes, update time, or the time when a role was registered to the confidentiality group or removed from the confidentiality group.
Column name | Type | Constraint | Description |
|---|---|---|---|
cgroid | bigint | primary key | Identifier of the confidentiality group. |
cgroname | varchar(63) | not null | Name of the confidentiality group. |
cgromatid | bigint | not null | Identifier of the confidentiality matrix to which the confidentiality group belongs. |
cgrocomment | text | Comment. | |
cgroupdatetime | timestamp with time zone | not null | Update time of the confidentiality group itself. |
cgrooperationtime | timestamp with time zone | The time when the role was added/deleted. | |
cgrorolename | name | not null | Name of the confidentiality group role. |
cgrosuperuser | bool | not null | true if the confidentiality group role has SUPERUSER privileges. |
cgrocreatedb | bool | not null | true if the confidentiality group role has CREATEDB privileges. |
cgrocreaterole | bool | not null | true if the confidentiality group role has CREATEROLE privileges. |
cgroreplication | bool | not null | true if the confidentiality group role has REPLICATION privileges. |
cgrobypassrls | bool | not null | true if the confidentiality group role has BYPASSRLS privileges. |
