V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BATCHTEMPLATEAPPROVER

Fields

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

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BATCHTEMPLATEAPPROVER_BATCHTEMPLATEID_APPUSERID	BATCHTEMPLATEID, APPUSERID
IX_V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BATCHTEMPLATEAPPROVER	APPUSERID, PERMID	yes		yes

Definition

Copy


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

                AS

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