v_FACT_SYSTEMPRIVILEGESECURITY
View that displays information about for system privilege security.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| SYSTEMPRIVILEGESECURITYFACTID | int | BBDW.[FACT_SYSTEMPRIVILEGESECURITY].[SYSTEMPRIVILEGESECURITYFACTID] | |
| PERMISSIONSYSTEMID | uniqueidentifier | yes | BBDW.[FACT_SYSTEMPRIVILEGESECURITY].[PERMISSIONSYSTEMID] |
| SYSTEMROLESYSTEMID | uniqueidentifier | yes | BBDW.[FACT_SYSTEMPRIVILEGESECURITY].[SYSTEMROLESYSTEMID] |
| SYSTEMROLEDIMID | int | yes | BBDW.[FACT_SYSTEMPRIVILEGESECURITY].[SYSTEMROLEDIMID] |
| SYSTEMPRIVILEGECATALOGID | uniqueidentifier | yes | BBDW.[FACT_SYSTEMPRIVILEGESECURITY].[SYSTEMPRIVILEGECATALOGID] |
| GRANTORDENY | bit | yes | BBDW.[FACT_SYSTEMPRIVILEGESECURITY].[GRANTORDENY] |
Definition
Copy
create view [BBDW].[v_FACT_SYSTEMPRIVILEGESECURITY] as
select
[SYSTEMPRIVILEGESECURITYFACTID],
[PERMISSIONSYSTEMID],
[SYSTEMROLESYSTEMID],
[SYSTEMROLEDIMID],
[SYSTEMPRIVILEGECATALOGID],
[GRANTORDENY]
from [BBDW].[FACT_SYSTEMPRIVILEGESECURITY];