v_SECURITY_SYSTEMROLEASSIGNMENT_USER_FORM
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| DATAFORMINSTANCECATALOGID | uniqueidentifier | yes | |
| APPUSERID | uniqueidentifier | yes | |
| APPUSERDIMID | int | yes | |
| GRANTORDENY | bit | yes | |
| PERMISSIONSYSTEMID | uniqueidentifier | yes | |
| SYSTEMROLEDIMID | int | yes | |
| SYSTEMROLEAPPUSERFACTID | int | ||
| RECORDSECURITYMODE | tinyint | yes | |
| SITESECURITYMODE | tinyint | yes |
Definition
Copy
create view BBDW.[v_SECURITY_SYSTEMROLEASSIGNMENT_USER_FORM] as
select
ds.[DATAFORMINSTANCECATALOGID],
sa.[APPUSERSYSTEMID] as [APPUSERID],
sa.[APPUSERDIMID],
ds.[GRANTORDENY],
ds.[PERMISSIONSYSTEMID],
sa.[SYSTEMROLEDIMID],
sa.[SYSTEMROLEAPPUSERFACTID],
sa.[CONSTITUENTSECURITYMODE] as [RECORDSECURITYMODE],
sa.[SITESECURITYMODE]
from BBDW.[FACT_DATAFORMINSTANCESECURITY] ds
inner join BBDW.[FACT_SYSTEMROLEAPPUSER] sa on ds.[SYSTEMROLEDIMID] = sa.[SYSTEMROLEDIMID]