UserInGroups


Description

User group memberships managing users’ assignments to security groups for hierarchical permission management. This table supports legacy group-based security alongside the newer role-based system, allowing for complex permission structures.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
UserID int 4 null
AccessUser.UserID FK_UserInGroups_AccessUser1 C

User reference - Links to AccessUser table for the user being assigned to a group
GroupID int 4 null
UserGroup.GroupID FK_UserInGroups_UserGroup C

Group reference - Links to UserGroup table for the security group
securityOrder int 4 √ null

Security order - Priority order for security group evaluation when user belongs to multiple groups

Indexes

Constraint Name Type Sort Column(s)
PK_UserInGroups Primary key Asc/Asc UserID + GroupID

Relationships

Close relationships within degrees of separation