V_SECURITY_SYSTEMROLEASSIGNMENT_USER_RECORDOPERATION
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| RECORDOPERATIONCATALOGID | uniqueidentifier | ||
| APPUSERID | uniqueidentifier | ||
| GRANTORDENY | bit | ||
| PERMID | uniqueidentifier | ||
| SYSTEMROLEID | uniqueidentifier | ||
| RECORDSECURITYMODE | tinyint | ||
| SITESECURITYMODE | tinyint | ||
| ACCOUNTINGELEMENTSECURITYMODE | tinyint |
Definition
Copy
CREATE view [dbo].[V_SECURITY_SYSTEMROLEASSIGNMENT_USER_RECORDOPERATION]
AS
select
RECORDOPERATIONCATALOGID,
APPUSERID,
GRANTORDENY,
PERMID,
SYSTEMROLEID,
RECORDSECURITYMODE,
SITESECURITYMODE,
ACCOUNTINGELEMENTSECURITYMODE
from
dbo.V_SECURITY_SYSTEMROLEASSIGNMENT_USER_RECORDOPERATION_BYROLE
with (NOEXPAND, INDEX(IX_V_SECURITY_SYSTEMROLEASSIGNMENT_USER_RECORDOPERATION_BYROLE_RECORDOPERATIONCATALOGID_APPUSERID))
union all
select
RECORDOPERATIONCATALOGID,
APPUSERID,
GRANTORDENY,
PERMID,
SYSTEMROLEID,
RECORDSECURITYMODE,
SITESECURITYMODE,
ACCOUNTINGELEMENTSECURITYMODE
from
dbo.V_SECURITY_SYSTEMROLEASSIGNMENT_USER_RECORDOPERATION_BYFEATUREGROUP
with (NOEXPAND, INDEX(IX_V_SECURITY_SYSTEMROLEASSIGNMENT_USER_RECORDOPERATION_BYFEATUREGROUP_RECORDOPERATIONCATALOGID_APPUSERID))