V_SECURITY_SYSTEMROLEASSIGNMENT_USER_CODETABLE
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 |
Definition
Copy
CREATE view [dbo].[V_SECURITY_SYSTEMROLEASSIGNMENT_USER_CODETABLE]
as
select
CODETABLECATALOGID,
APPUSERID,
ADDPERMISSIONCODE,
UPDATEPERMISSIONCODE,
DELETEPERMISSIONCODE,
PERMID,
SYSTEMROLEID,
SITESECURITYMODE
from dbo.V_SECURITY_SYSTEMROLEASSIGNMENT_USER_CODETABLE_BYROLE
with (NOEXPAND, INDEX(IX_V_SECURITY_SYSTEMROLEASSIGNMENT_USER_CODETABLE_BYROLE_CODETABLECATALOGID_APPUSERID))
union all
select
CODETABLECATALOGID,
APPUSERID,
ADDPERMISSIONCODE,
UPDATEPERMISSIONCODE,
DELETEPERMISSIONCODE,
PERMID,
SYSTEMROLEID,
SITESECURITYMODE
from dbo.V_SECURITY_SYSTEMROLEASSIGNMENT_USER_CODETABLE_BYFEATUREGROUP
with (NOEXPAND, INDEX(IX_V_SECURITY_SYSTEMROLEASSIGNMENT_USER_CODETABLE_BYFEATUREGROUP_CODETABLECATALOGID_APPUSERID));