V_SECURITY_SYSTEMROLEASSIGNMENT_USER_CODETABLE_BYROLE
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| CODETABLECATALOGID | uniqueidentifier | ||
| APPUSERID | uniqueidentifier | ||
| ADDPERMISSIONCODE | tinyint | ||
| UPDATEPERMISSIONCODE | tinyint | ||
| DELETEPERMISSIONCODE | tinyint | ||
| PERMID | uniqueidentifier | ||
| SYSTEMROLEID | uniqueidentifier | ||
| SITESECURITYMODE | tinyint |
Indexes
| Index Name | Fields | Unique | Primary | Clustered |
|---|---|---|---|---|
| IX_V_SECURITY_SYSTEMROLEASSIGNMENT_USER_CODETABLE_BYROLE_CODETABLECATALOGID_APPUSERID | CODETABLECATALOGID, APPUSERID | |||
| IX_V_SECURITY_SYSTEMROLEASSIGNMENT_USER_CODETABLE_BYROLE | APPUSERID, PERMID | yes | yes |
Definition
Copy
create view [dbo].[V_SECURITY_SYSTEMROLEASSIGNMENT_USER_CODETABLE_BYROLE] with SCHEMABINDING
/*Indexed view used to evaluate Security for code tables
Includes a row for every system role/user/record operation permission that has been assigned.
*/
as
select
SYSTEMROLEPERM_CODETABLE.CODETABLECATALOGID,
SYSTEMROLEAPPUSER.APPUSERID,
SYSTEMROLEPERM_CODETABLE.ADDPERMISSIONCODE,
SYSTEMROLEPERM_CODETABLE.UPDATEPERMISSIONCODE,
SYSTEMROLEPERM_CODETABLE.DELETEPERMISSIONCODE,
SYSTEMROLEPERM_CODETABLE.ID AS [PERMID],
SYSTEMROLEPERM_CODETABLE.SYSTEMROLEID,
SYSTEMROLEAPPUSER.SECURITYMODECODE as SITESECURITYMODE
from dbo.SYSTEMROLEPERM_CODETABLE
inner join dbo.SYSTEMROLE
on SYSTEMROLE.ID = SYSTEMROLEPERM_CODETABLE.SYSTEMROLEID
inner join dbo.SYSTEMROLEAPPUSER
on SYSTEMROLEPERM_CODETABLE.SYSTEMROLEID = SYSTEMROLEAPPUSER.SYSTEMROLEID;