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