PRIVILEGE_GROUP_MEMBERSHIP table

The PRIVILEGE_GROUP_MEMBERSHIP table represents the N:N relationship between users and privilege groups. The clustering key is the PRIV_GROUP_UID and USERID columns.

The table has an index, PG_MEMBERSHIP_BY_USERID, on the USERID column.

Column number

Column Name

Data Type

Description

1*

PRIV_GROUP_UID

INT

Links to the PRIV_GROUP_UID of the PRIVILEGE_GROUPS table.

2*

USERID

LARGEINT

Links to the USERID if the DATABASE_USERS table.

* Indicates primary key