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