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)

  • G - A Guardian user group (UID in the interval [0:255]). The system owns this privilege group.

  • E - An explicit privilege group, created by the CREATE PRIVILEGE GROUP command (UID >= 65536). The user who creates the privilege group owns it.

  • MD - A multi-tenancy default privilege group, created when a tenant database is created (UID in the interval [256:65535]). The global DBS administrator user that created the user database owns the privilege group.

  • TR - A multi-tenancy read access privilege group, created when a tenant database is created. The global DBS administrator user that created the user database owns the privilege group.

  • TW - A multi-tenancy write access privilege group, created when a tenant database is created. The global DBS administrator user that created the user database owns the privilege group.

  • TC - A multi-tenancy create access privilege group, created when a tenant database is created. The global DBS administrator user that created the user database owns the privilege group.

    A implicit privilege group has a type of MD, TR, TW, or TC

* Indicates primary key