v_SECURITY_SYSTEMROLEASSIGNMENT_USER_REPORT
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| REPORTCATALOGID | 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_REPORT] as
select
ds.[REPORTCATALOGID],
sa.[APPUSERSYSTEMID] as [APPUSERID],
sa.[APPUSERDIMID],
ds.[GRANTORDENY],
ds.[PERMISSIONSYSTEMID],
sa.[SYSTEMROLEDIMID],
sa.[SYSTEMROLEAPPUSERFACTID],
sa.[CONSTITUENTSECURITYMODE] as [RECORDSECURITYMODE],
sa.[SITESECURITYMODE]
from BBDW.[FACT_REPORTSECURITY] ds
inner join BBDW.[FACT_SYSTEMROLEAPPUSER] sa on ds.[SYSTEMROLEDIMID] = sa.[SYSTEMROLEDIMID]