V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BATCHPROCESSOR

Fields

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

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BATCHTEMPLATEPROCESSOR_BATCHTEMPLATEID_APPUSERID	BATCHTEMPLATEID, APPUSERID
IX_V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BATCHTEMPLATEPROCESSOR	APPUSERID, PERMID	yes		yes

Definition

Copy


                CREATE view [dbo].[V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BATCHPROCESSOR] with SCHEMABINDING
                /*Indexed view used to evaluate Security for batch processors
                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.SECURITYMODECODE as SITESECURITYMODE,
                    SRAU.CONSTITUENTSECURITYMODECODE as RECORDSECURITYMODE
                from dbo.SYSTEMROLEPERM_BATCHTEMPLATEPROCESSOR as SRP
                    inner join dbo.SYSTEMROLE as SR on SRP.SYSTEMROLEID=SR.ID
                    inner join dbo.SYSTEMROLEAPPUSER as SRAU on SRP.SYSTEMROLEID=SRAU.SYSTEMROLEID