PRIVILEGE_GROUPS table
The table PRIVILEGE_GROUPS represents privilege groups. A privilege group can be the target of a GRANT or REVOKE command. The privileges granted to a privilege group affect all the existing and future users in that group.
A Guardian user group is a type of privilege group that has automatic membership if the group is created.
The table has a unique index, PRIV_GROUP_BY_ID, on the PRIV_GROUP_UID column.
Column number |
Column Name |
Data Type |
Description |
1* |
PRIV_GROUP_NAME |
CHAR(128) |
The name of the privilege group. |
2 |
PRIV_GROUP_UID |
INT |
The unique ID for the privilege group. |
3 |
PRIV_GROUP_OWNER |
INT |
The Guardian user ID of the group owner. It must be a part of the DATABASE_USERS. |
4 |
PRIV_GROUP_TYPE |
CHAR(2) |
|
* Indicates primary key |