v_FACT_SMARTQUERYSECURITY
Stores permissions for smart queries.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| SMARTQUERYSECURITYFACTID | int | BBDW.[FACT_SMARTQUERYSECURITY].[SMARTQUERYSECURITYFACTID] | |
| PERMISSIONSYSTEMID | uniqueidentifier | yes | BBDW.[FACT_SMARTQUERYSECURITY].[PERMISSIONSYSTEMID] |
| SMARTQUERYCATALOGID | uniqueidentifier | yes | BBDW.[FACT_SMARTQUERYSECURITY].[SMARTQUERYCATALOGID] |
| SYSTEMROLEDIMID | int | yes | BBDW.[FACT_SMARTQUERYSECURITY].[SYSTEMROLEDIMID] |
| GRANTORDENY | bit | yes | BBDW.[FACT_SMARTQUERYSECURITY].[GRANTORDENY] |
Definition
Copy
create view [BBDW].[v_FACT_SMARTQUERYSECURITY] as
select
[SMARTQUERYSECURITYFACTID],
[PERMISSIONSYSTEMID],
[SMARTQUERYCATALOGID],
[SYSTEMROLEDIMID],
[GRANTORDENY]
from [BBDW].[FACT_SMARTQUERYSECURITY];