V_SECURITY_SYSTEMROLEASSIGNMENT_USER_SMARTQUERY
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| SMARTQUERYCATALOGID | 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 |
Definition
Copy
create view [BBDW].[V_SECURITY_SYSTEMROLEASSIGNMENT_USER_SMARTQUERY]
as
select
sq.[SMARTQUERYCATALOGID],
sa.[APPUSERSYSTEMID] as [APPUSERID],
sa.[APPUSERDIMID],
sq.[GRANTORDENY],
sq.[PERMISSIONSYSTEMID],
sa.[SYSTEMROLEDIMID],
sa.[SYSTEMROLEAPPUSERFACTID],
sa.[CONSTITUENTSECURITYMODE],
sa.[SITESECURITYMODE]
from BBDW.[FACT_SMARTQUERYSECURITY] sq
inner join BBDW.[FACT_SYSTEMROLEAPPUSER] sa on sq.[SYSTEMROLEDIMID] = sa.[SYSTEMROLEDIMID];