V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BATCHTEMPLATE
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| BATCHTEMPLATEID | uniqueidentifier | ||
| APPUSERID | uniqueidentifier | ||
| GRANTORDENY | bit | ||
| PERMID | uniqueidentifier | ||
| SYSTEMROLEID | uniqueidentifier | ||
| SITESECURITYMODE | tinyint | ||
| RECORDSECURITYMODE | tinyint | ||
| SITEID | uniqueidentifier | yes |
Indexes
| Index Name | Fields | Unique | Primary | Clustered |
|---|---|---|---|---|
| IX_V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BATCHTEMPLATE_BATCHTEMPLATEID_APPUSERID | BATCHTEMPLATEID, APPUSERID | |||
| IX_V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BATCHTEMPLATE_BATCHTEMPLATEID_APPUSERID_GRANTORDENY | BATCHTEMPLATEID, APPUSERID, GRANTORDENY | |||
| IX_V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BATCHTEMPLATE | APPUSERID, PERMID | yes | yes |
Definition
Copy
CREATE view [dbo].[V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BATCHTEMPLATE] 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 GRANTORDENY,
SRP.ID AS [PERMID],
SRP.SYSTEMROLEID,
SRAU.SECURITYMODECODE as SITESECURITYMODE,
SRAU.CONSTITUENTSECURITYMODECODE as RECORDSECURITYMODE,
BATCHTEMPLATE.SITEID
from dbo.SYSTEMROLEPERM_BATCHTEMPLATE as SRP
inner join dbo.SYSTEMROLE as SR on SRP.SYSTEMROLEID=SR.ID
inner join dbo.SYSTEMROLEAPPUSER as SRAU on SRP.SYSTEMROLEID=SRAU.SYSTEMROLEID
inner join dbo.BATCHTEMPLATE on BATCHTEMPLATE.ID = SRP.BATCHTEMPLATEID