V_SECURITY_SYSTEMROLEASSIGNMENT_USER_CODETABLE_BYFEATUREGROUP
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| CODETABLECATALOGID | uniqueidentifier | ||
| APPUSERID | uniqueidentifier | ||
| ADDPERMISSIONCODE | tinyint | yes | |
| UPDATEPERMISSIONCODE | tinyint | yes | |
| DELETEPERMISSIONCODE | tinyint | yes | |
| PERMID | uniqueidentifier | ||
| SYSTEMROLEID | uniqueidentifier | ||
| SITESECURITYMODE | tinyint |
Indexes
| Index Name | Fields | Unique | Primary | Clustered |
|---|---|---|---|---|
| IX_V_SECURITY_SYSTEMROLEASSIGNMENT_USER_CODETABLE_BYFEATUREGROUP_CODETABLECATALOGID_APPUSERID | CODETABLECATALOGID, APPUSERID | |||
| IX_V_SECURITY_SYSTEMROLEASSIGNMENT_USER_CODETABLE_BYFEATUREGROUP | APPUSERID, PERMID, SYSTEMROLEID | yes | yes |
Definition
Copy
CREATE view [dbo].[V_SECURITY_SYSTEMROLEASSIGNMENT_USER_CODETABLE_BYFEATUREGROUP] with SCHEMABINDING
as
select
FEATUREGROUPFEATURE.FEATUREID CODETABLECATALOGID,
SYSTEMROLEAPPUSER.APPUSERID,
/*
If the user is granted rights to a code table via a feature group, allow the user to add, update and delete.
Note that for code tables, 1 = granted and 2 = denied.
*/
cast(case SYSTEMROLEPERM_FEATUREGROUP.GRANTORDENY when 0 then 2 else 1 end as tinyint) ADDPERMISSIONCODE,
cast(case SYSTEMROLEPERM_FEATUREGROUP.GRANTORDENY when 0 then 2 else 1 end as tinyint) UPDATEPERMISSIONCODE,
cast(case SYSTEMROLEPERM_FEATUREGROUP.GRANTORDENY when 0 then 2 else 1 end as tinyint) DELETEPERMISSIONCODE,
FEATUREGROUPFEATURE.ID AS [PERMID],
SYSTEMROLEPERM_FEATUREGROUP.SYSTEMROLEID,
SYSTEMROLEAPPUSER.SECURITYMODECODE as SITESECURITYMODE
from dbo.SYSTEMROLEPERM_FEATUREGROUP
inner join dbo.SYSTEMROLE
on SYSTEMROLE.ID = SYSTEMROLEPERM_FEATUREGROUP.SYSTEMROLEID
inner join dbo.SYSTEMROLEAPPUSER
on SYSTEMROLEPERM_FEATUREGROUP.SYSTEMROLEID = SYSTEMROLEAPPUSER.SYSTEMROLEID
inner join dbo.FEATUREGROUPFEATURE on SYSTEMROLEPERM_FEATUREGROUP.FEATUREGROUPCATALOGID = FEATUREGROUPFEATURE.FEATUREGROUPCATALOGID
and FEATUREGROUPFEATURE.FEATURETYPECODE = 2;