Purpose
Determines which Groups the User is a member of.
Access to Instance Records is maintained by the InstanceAccess table. Any Instance record can be made accessible to any User, or Group of Users.
Definition
CREATE TABLE [dbo].[UserGroups](
[UserGUID] [UNIQUEIDENTIFIER] NOT NULL,
[GroupGUID] [UNIQUEIDENTIFIER] NOT NULL,
CONSTRAINT [PK_UserGroups] PRIMARY KEY CLUSTERED
(
[UserGUID] ASC,
[GroupGUID] ASC
)WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
Column Definitions
UserGUID is the InstanceGUID of the user’s Instance record
GroupGUID is the InstanceGUID of a Group’s Instance record that the User is a member of.
Key Functionality
Has an optional trigger to move changes in access rights to other data storage through the InstanceChanges table.