V_SECURITY_SYSTEMROLEASSIGNMENT_USER_TASK

Fields

Field	Field Type	Null	Description
TASKID	uniqueidentifier
APPUSERID	uniqueidentifier
PERMID	uniqueidentifier
SYSTEMROLEID	uniqueidentifier
RECORDSECURITYMODE	tinyint
SITESECURITYMODE	tinyint

Definition

Copy


CREATE view [dbo].[V_SECURITY_SYSTEMROLEASSIGNMENT_USER_TASK]
AS
    select 
        TASKID,
        APPUSERID,
        PERMID,
        SYSTEMROLEID,
        RECORDSECURITYMODE,
        SITESECURITYMODE
    from 
        dbo.V_SECURITY_SYSTEMROLEASSIGNMENT_USER_TASK_BYROLE
    with (NOEXPAND, INDEX(IX_V_SECURITY_SYSTEMROLEASSIGNMENT_USER_TASK_BYROLE_TASKID_APPUSERID))
    union all
    select 
        TASKID,
        APPUSERID,
        PERMID,
        SYSTEMROLEID,
        RECORDSECURITYMODE,
        SITESECURITYMODE
    from 
        dbo.V_SECURITY_SYSTEMROLEASSIGNMENT_USER_TASK_BYFEATUREGROUP
    with (NOEXPAND, INDEX(IX_V_SECURITY_SYSTEMROLEASSIGNMENT_USER_TASK_BYFEATUREGROUP_TASKID_APPUSERID))