V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BATCHWORKFLOWSTATE

Fields

Field	Field Type	Null	Description
BATCHWORKFLOWSTATEID	uniqueidentifier
APPUSERID	uniqueidentifier
GRANTORDENY	bit
PERMID	uniqueidentifier
SYSTEMROLEID	uniqueidentifier
RECORDSECURITYMODE	tinyint
SITESECURITYMODE	tinyint

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BATCHWORKFLOWSTATE_BATCHWORKFLOWSTATEID_APPUSERID	BATCHWORKFLOWSTATEID, APPUSERID
IX_V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BATCHWORKFLOWSTATE	APPUSERID, PERMID	yes		yes

Definition

Copy


        CREATE view [dbo].[V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BATCHWORKFLOWSTATE] with SCHEMABINDING
        /*Indexed view used to evaluate Security for batch states
        Includes a row for every system role/user/record operation permission that has been assigned.
        */
        as

        select
          SRP.BATCHWORKFLOWSTATEID,
          SRAU.APPUSERID,
          SRP.GRANTORDENY,
          SRP.ID AS [PERMID],
          SRP.SYSTEMROLEID,
          SRAU.CONSTITUENTSECURITYMODECODE as RECORDSECURITYMODE,
          SRAU.SECURITYMODECODE as SITESECURITYMODE
        from
          dbo.SYSTEMROLEPERM_BATCHWORKFLOWSTATE as SRP
        inner join
          dbo.SYSTEMROLE as SR on SRP.SYSTEMROLEID = SR.ID
        inner join
          dbo.SYSTEMROLEAPPUSER as SRAU on SRP.SYSTEMROLEID = SRAU.SYSTEMROLEID