v_FACT_DATALISTSECURITY
Surrogate key for the datalist security fact
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| DATALISTSECURITYFACTID | int | BBDW.[FACT_DATALISTSECURITY].[DATALISTSECURITYFACTID] | |
| PERMISSIONSYSTEMID | uniqueidentifier | yes | BBDW.[FACT_DATALISTSECURITY].[PERMISSIONSYSTEMID] |
| DATALISTCATALOGID | uniqueidentifier | yes | BBDW.[FACT_DATALISTSECURITY].[DATALISTCATALOGID] |
| SYSTEMROLEDIMID | int | yes | BBDW.[FACT_DATALISTSECURITY].[SYSTEMROLEDIMID] |
| GRANTORDENY | bit | yes | BBDW.[FACT_DATALISTSECURITY].[GRANTORDENY] |
Definition
Copy
create view [BBDW].[v_FACT_DATALISTSECURITY] as
select
[DATALISTSECURITYFACTID],
[PERMISSIONSYSTEMID],
[DATALISTCATALOGID],
[SYSTEMROLEDIMID],
[GRANTORDENY]
from [BBDW].[FACT_DATALISTSECURITY];