PRIVILEGE_GROUP_GRANTS table

The PRIVILEGE_GROUP_GRANTS table contains information about grants to privilege group for user schemas.

The clustering key is the PRIV_GROUP_ID, CAT_UID, SCHEMA_UID, and OBJECT_UID columns.

The table has an index, PG_GRANT_BY_TARGET, on the CAT_UID, SCHEMA_UID, and OBJECT_UID columns.

Column number

Column Name

Data Type

Description

1*

PRIV_GROUP_UID

INT

Links to the PRIV_GROUP_UID of the PRIVILEGE_GROUPS table.

2*

CAT_UID

LARGEINT

Links to the CAT_UID of the CATSYS table.

3*

SCHEMA_UID

LARGEINT

Links to the SCHEMA_UID of the SCHEMATA table.

4*

OBJECT_UID

LARGEINT

Links to the OBJECT_UID of the OBJECTS table.

* Indicates primary key