Purpose
Determines which roles the user has access to as they interact with the user experience.
Roles act as fine-gained controls on Form, Field, Command and Event functionality rendered through the Dynamic Page Builder.
CREATE TABLE [dbo].[UserRoles](
[UserGUID] [UNIQUEIDENTIFIER] NOT NULL,
[RoleGUID] [UNIQUEIDENTIFIER] NOT NULL,
CONSTRAINT [PK_UserRoles] PRIMARY KEY CLUSTERED
(
[UserGUID] ASC,
[RoleGUID] 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
RoleGUID is the InstanceGUID of a Role Instance record that defines the fine-grained functionality available to the user.
Key Functionality
Has an optional trigger to transfer changes to other data storage through InstanceChanges.