V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BUSINESSPROCESS_BYFEATUREGROUP
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| BUSINESSPROCESSCATALOGID | 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_BUSINESSPROCESS_BYFEATUREGROUP_BUSINESSPROCESSCATALOGID_APPUSERID | BUSINESSPROCESSCATALOGID, APPUSERID | |||
| IX_V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BUSINESSPROCESS_BYFEATUREGROUP | APPUSERID, PERMID, SYSTEMROLEID | yes | yes |
Definition
Copy
CREATE view [dbo].[V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BUSINESSPROCESS_BYFEATUREGROUP] with SCHEMABINDING
/*
Indexed view used to evaluate Security for business processes
Includes a row for every system role/user/businessprocess permission that has been assigned.
*/
AS
select
FEATUREGROUPFEATURE.FEATUREID BUSINESSPROCESSCATALOGID,
SRAU.APPUSERID ,
SRP.GRANTORDENY,
FEATUREGROUPFEATURE.ID AS [PERMID],
SRP.SYSTEMROLEID,
SRAU.CONSTITUENTSECURITYMODECODE as RECORDSECURITYMODE,
SRAU.SECURITYMODECODE as SITESECURITYMODE
from dbo.SYSTEMROLEPERM_FEATUREGROUP 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.FEATUREGROUPFEATURE on SRP.FEATUREGROUPCATALOGID = FEATUREGROUPFEATURE.FEATUREGROUPCATALOGID
and FEATUREGROUPFEATURE.FEATURETYPECODE = 1;