V_SECURITY_SYSTEMROLEASSIGNMENT_USER_SYSTEMPRIVILEGE_BYFEATUREGROUP
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| SYSTEMPRIVILEGECATALOGID | 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_SYSTEMPRIVILEGE_BYFEATUREGROUP_SYSTEMPRIVILEGECATALOGID_APPUSERID | SYSTEMPRIVILEGECATALOGID, APPUSERID | |||
| IX_V_SECURITY_SYSTEMROLEASSIGNMENT_USER_SYSTEMPRIVILEGE_BYFEATUREGROUP | APPUSERID, PERMID, SYSTEMROLEID | yes | yes |
Definition
Copy
CREATE view [dbo].[V_SECURITY_SYSTEMROLEASSIGNMENT_USER_SYSTEMPRIVILEGE_BYFEATUREGROUP] with SCHEMABINDING
AS
select
FEATUREGROUPFEATURE.FEATUREID SYSTEMPRIVILEGECATALOGID,
SYSTEMROLEAPPUSER.APPUSERID,
SYSTEMROLEPERM_FEATUREGROUP.GRANTORDENY,
FEATUREGROUPFEATURE.ID AS [PERMID],
SYSTEMROLEPERM_FEATUREGROUP.SYSTEMROLEID,
SYSTEMROLEAPPUSER.CONSTITUENTSECURITYMODECODE as RECORDSECURITYMODE,
SYSTEMROLEAPPUSER.SECURITYMODECODE as SITESECURITYMODE
from
dbo.SYSTEMROLEPERM_FEATUREGROUP
inner join dbo.SYSTEMROLE on SYSTEMROLEPERM_FEATUREGROUP.SYSTEMROLEID=SYSTEMROLE.ID
inner join dbo.SYSTEMROLEAPPUSER on SYSTEMROLEPERM_FEATUREGROUP.SYSTEMROLEID=SYSTEMROLEAPPUSER.SYSTEMROLEID
inner join dbo.FEATUREGROUPFEATURE on SYSTEMROLEPERM_FEATUREGROUP.FEATUREGROUPCATALOGID = FEATUREGROUPFEATURE.FEATUREGROUPCATALOGID
and FEATUREGROUPFEATURE.FEATURETYPECODE = 13;