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 |