v_SECURITY_SYSTEMROLEASSIGNMENT_USER_SYSTEMPRIVILEGE
Intermediate storage table for system privilege security.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| SYSTEMPRIVILEGECATALOGID | uniqueidentifier | yes | BBDW.[FACT_SYSTEMPRIVILEGESECURITY].[SYSTEMPRIVILEGECATALOGID] |
| APPUSERID | uniqueidentifier | yes | BBDW.[FACT_SYSTEMROLEAPPUSER].[APPUSERSYSTEMID] |
| GRANTORDENY | bit | yes | BBDW.[FACT_SYSTEMPRIVILEGESECURITY].[GRANTORDENY] |
| SYSTEMROLEID | uniqueidentifier | yes | BBDW.[FACT_SYSTEMPRIVILEGESECURITY].[SYSTEMROLESYSTEMID] |
| PERMID | uniqueidentifier | yes | BBDW.[FACT_SYSTEMPRIVILEGESECURITY].[PERMISSIONSYSTEMID] |
| RECORDSECURITYMODE | tinyint | yes | BBDW.[FACT_SYSTEMROLEAPPUSER].[SITESECURITYMODE] |
| SITESECURITYMODE | tinyint | yes |
Definition
Copy
create view [BBDW].[v_SECURITY_SYSTEMROLEASSIGNMENT_USER_SYSTEMPRIVILEGE] as
select
ss.[SYSTEMPRIVILEGECATALOGID],
sa.[APPUSERSYSTEMID] as [APPUSERID],
ss.[GRANTORDENY],
ss.[SYSTEMROLESYSTEMID] as [SYSTEMROLEID],
ss.[PERMISSIONSYSTEMID] as [PERMID],
sa.[CONSTITUENTSECURITYMODE] as [RECORDSECURITYMODE],
sa.[SITESECURITYMODE]
from [BBDW].[FACT_SYSTEMPRIVILEGESECURITY] ss
inner join BBDW.[FACT_SYSTEMROLEAPPUSER] sa on ss.[SYSTEMROLEDIMID] = sa.[SYSTEMROLEDIMID];