V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BUSINESSPROCESS_BYROLE
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_BYROLE_BUSINESSPROCESSCATALOGID_APPUSERID | BUSINESSPROCESSCATALOGID, APPUSERID | |||
| IX_V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BUSINESSPROCESS_BYROLE | APPUSERID, PERMID | yes | yes |
Definition
Copy
CREATE view [dbo].[V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BUSINESSPROCESS_BYROLE] 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
SRP.BUSINESSPROCESSCATALOGID,
SRAU.APPUSERID ,
SRP.GRANTORDENY,
SRP.ID AS [PERMID],
SRP.SYSTEMROLEID,
SRAU.CONSTITUENTSECURITYMODECODE as RECORDSECURITYMODE,
SRAU.SECURITYMODECODE as SITESECURITYMODE
from dbo.SYSTEMROLEPERM_BUSINESSPROCESS as SRP
--inner join dbo.SYSTEMROLE as SR on SRP.SYSTEMROLEID=SR.ID
inner join dbo.SYSTEMROLEAPPUSER as SRAU on SRP.SYSTEMROLEID=SRAU.SYSTEMROLEID