TBL_GROUP_PRIVILEGES table
The TBL_GROUP_PRIVILEGES table stores grant information for tables, views, sequence generators, and stored procedures in the catalog where the grantee is a privilege group. Corresponding grant information for individual columns is stored in the COL_GROUP_PRIVILEGES table.
The clustering key consists of TABLE_UID, GRANTOR, GRANTOR_TYPE, GRANTEE, GRANTEE_TYPE, and PRIVILEGE_TYPE. The layout of the TBL_GROUP_PRIVILEGES table is identical to that of the SCH_GROUP_PRIVILEGES, SCH_PRIVILEGES, and TBL_PRIVILEGES tables.
|
Column number |
Column Name |
Data Type |
Description |
|
1* |
GRANTOR |
INT |
Authorization ID of grantor or owner if grantor is super ID acting for owner. |
|
2* |
GRANTOR_TYPE |
CHAR(2) |
The values are: U if user grant O if granted as schema owner The system never performs privilege group grants. |
|
3* |
GRANTEE |
INT |
The privilege Group UID of the grantee. It links to PRIVILEGE_GROUPS in the SYSTEM_SECURITY_SCHEMA. |
|
4* |
GRANTEE_TYPE |
CHAR(2) |
The value is U, which indicates that a privilege group can be neither owner nor PUBLIC. |
|
5* |
TABLE_UID |
LARGEINT |
The UID of the schema label object in the target schema. |
|
6* |
PRIVILEGE_TYPE |
CHAR(2) |
The privilege types are: D - DELETE E - EXECUTE I - INSERT R - REFERENCES S - SELECT U - UPDATE |
|
7 |
IS_GRANTABLE |
CHAR(2) |
The value is N, which indicates that the WITH GRANT OPTION does not apply to privilege group grants |
|
* Indicates primary key |
|||