Table LS_USER_GROUP

The group membership table. This table contains the many-to-many relationship between users and groups. Each user may belong to multiple groups, and each group may contain multiple users. Each row in this table corresponds to a user membership in a particular group.

Column Detail

DOMAIN

DOMAIN VARCHAR(30) NOT NULL

The name of the domain that the user and group belongs to.

Reference To:

LS_DOMAIN.NAME
LS_USER.DOMAIN
LS_GROUP.DOMAIN

USER

USER VARCHAR(30) NOT NULL

The user name.

Reference To:

LS_USER.NAME

GROUP

GROUP VARCHAR(30) NOT NULL

The group name.

Reference To:

LS_GROUP.NAME

Index Detail

PRIMARY KEY

PRIMARY KEY (DOMAIN, USER, GROUP)

The group membership is uniquely indexed by domain, user and group.

INDEX USER_GROUP_IDX1

INDEX USER_GROUP_IDX1 (DOMAIN, USER)

This index facilitates searches for the groups that a user belongs to.

INDEX USER_GROUP_IDX2

INDEX USER_GROUP_IDX2 (DOMAIN, GROUP)

This index facilitates searches for the users belonging to a particular group.