v_FACT_QUERYVIEWSECURITY
Intermediate storage table for query view security
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| QUERYVIEWSECURITYFACTID | int | BBDW.[FACT_QUERYVIEWSECURITY].[QUERYVIEWSECURITYFACTID] | |
| PERMISSIONSYSTEMID | uniqueidentifier | yes | BBDW.[FACT_QUERYVIEWSECURITY].[PERMISSIONSYSTEMID] |
| QUERYVIEWCATALOGID | uniqueidentifier | yes | BBDW.[FACT_QUERYVIEWSECURITY].[QUERYVIEWCATALOGID] |
| SYSTEMROLEDIMID | int | yes | BBDW.[FACT_QUERYVIEWSECURITY].[SYSTEMROLEDIMID] |
| GRANTORDENY | bit | yes | BBDW.[FACT_QUERYVIEWSECURITY].[GRANTORDENY] |
Definition
Copy
create view [BBDW].[v_FACT_QUERYVIEWSECURITY] as
select
[QUERYVIEWSECURITYFACTID],
[PERMISSIONSYSTEMID],
[QUERYVIEWCATALOGID],
[SYSTEMROLEDIMID],
[GRANTORDENY]
from [BBDW].[FACT_QUERYVIEWSECURITY];