v_FACT_REPORTSECURITY
Surrogate key for the report security fact
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| REPORTSECURITYFACTID | int | BBDW.[FACT_REPORTSECURITY].[REPORTSECURITYFACTID] | |
| PERMISSIONSYSTEMID | uniqueidentifier | yes | BBDW.[FACT_REPORTSECURITY].[PERMISSIONSYSTEMID] |
| REPORTCATALOGID | uniqueidentifier | yes | BBDW.[FACT_REPORTSECURITY].[REPORTCATALOGID] |
| SYSTEMROLEDIMID | int | yes | BBDW.[FACT_REPORTSECURITY].[SYSTEMROLEDIMID] |
| GRANTORDENY | bit | yes | BBDW.[FACT_REPORTSECURITY].[GRANTORDENY] |
Definition
Copy
create view [BBDW].[v_FACT_REPORTSECURITY] as
select
[REPORTSECURITYFACTID],
[PERMISSIONSYSTEMID],
[REPORTCATALOGID],
[SYSTEMROLEDIMID],
[GRANTORDENY]
from [BBDW].[FACT_REPORTSECURITY];