vr_UserWindowAccess

Updated March 24, 2026 14:55

Field Name	Field Description	Data Type	FK Join
UserId	User Id	int	vr_users
SystemRoleId	System Role Id	int	vt_SystemRoles
Id	Window Id	int	vr_webtmaWindows
Name	Window Name	nvarchar
MenuId	Menu Id	int
WindowCanView	Can View Window attibrute	int
WindowCanAdd	Can Add Window attibrute	int
WindowCanEdit	Can Edit Window attibrute	int
WindowCanDelete	Can Delete Window attibrute	int
CanView	Can View	int
CanAdd	Can Add	int
CanEdit	Can Edit	int
CanDelete	Can Delete	int
GroupCanView	Inherent Can View from Group	int
GroupCanAdd	Inherent Can Add from Group	int
GroupCanEdit	Inherent Can Edit from Group	int
GroupCanDelete	Inherent Can Delete from Group	int
EffectiveViewAccess	Effective View Access (Combined access from groups and user)	int
EffectiveAddAccess	Effective Add Access (Combined access from groups and user)	int
EffectiveEditAccess	Effective Edit Access (Combined access from groups and user)	int
EffectiveDeleteAccess	Effective Delete Access (Combined access from groups and user)	int
EffectiveCopyAccess	Effective Copy Access (Combined access from groups and user)	int