v_FACT_DATAFORMINSTANCESECURITY
Surrogate key for the data form instance security fact
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| DATAFORMINSTANCESECURITYFACTID | int | BBDW.[FACT_DATAFORMINSTANCESECURITY].[DATAFORMINSTANCESECURITYFACTID] | |
| PERMISSIONSYSTEMID | uniqueidentifier | yes | BBDW.[FACT_DATAFORMINSTANCESECURITY].[PERMISSIONSYSTEMID] |
| DATAFORMINSTANCECATALOGID | uniqueidentifier | yes | BBDW.[FACT_DATAFORMINSTANCESECURITY].[DATAFORMINSTANCECATALOGID] |
| SYSTEMROLEDIMID | int | yes | BBDW.[FACT_DATAFORMINSTANCESECURITY].[SYSTEMROLEDIMID] |
| GRANTORDENY | bit | yes | BBDW.[FACT_DATAFORMINSTANCESECURITY].[GRANTORDENY] |
Definition
Copy
create view [BBDW].[v_FACT_DATAFORMINSTANCESECURITY] as
select
[DATAFORMINSTANCESECURITYFACTID],
[PERMISSIONSYSTEMID],
[DATAFORMINSTANCECATALOGID],
[SYSTEMROLEDIMID],
[GRANTORDENY]
from [BBDW].[FACT_DATAFORMINSTANCESECURITY];