Table – UserRoles

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.

Updated on November 24, 2022

Was this article helpful?

Related Articles

Need Support?
Can’t find the answer you’re looking for? Don’t worry we’re here to help!
Contact Support

Leave a Comment