COL_GROUP_PRIVILEGES table
The COL_GROUP_PRIVILEGES table stores grant information for columns in the catalog where the grantee is a privilege. The corresponding grant information for the table is stored separately in the TBL_GROUP_PRIVILEGES table.
Column number |
Column Name |
Data Type |
Description |
1* |
TABLE_UID |
LARGEINT |
The UID of the table. |
2* |
COLUMN_NUMBER |
INT |
The position within table. The first column is 0. |
3 * |
GRANTOR |
INT |
The authorization ID of the grantor or of the owner if the grantor is super ID acting for owner. |
4 * |
GRANTOR_TYPE |
CHAR(2) |
The value is U if user grant. The value is O if granted as schema owner. The system never performs privilege group grants. |
5* |
GRANTEE |
INT |
The privilege Group UID of the grantee. Links to PRIVILEGE_GROUPS in the SYSTEM_SECURITY_SCHEMA. |
6* |
GRANTEE_TYPE |
CHAR(2) |
The value is U – a privilege group can be neither owner nor PUBLIC. |
7* |
PRIVILEGE_TYPE |
CHAR(2) |
The privilege type is:
|
8 |
IS_GRANTABLE |
CHAR(2) |
The value N – WITH GRANT OPTION does not apply to privilege group grants. |
* Indicates primary key |