V_SECURITY_SYSTEMROLEASSIGNMENT_USER_SMARTQUERY

Fields

Field	Field Type	Null	Description
SMARTQUERYCATALOGID	uniqueidentifier
APPUSERID	uniqueidentifier
GRANTORDENY	bit
PERMID	uniqueidentifier
SYSTEMROLEID	uniqueidentifier
RECORDSECURITYMODE	tinyint
SITESECURITYMODE	tinyint

Definition

Copy


CREATE view [dbo].[V_SECURITY_SYSTEMROLEASSIGNMENT_USER_SMARTQUERY]
as
    select
        SMARTQUERYCATALOGID,
        APPUSERID,
        GRANTORDENY,
        PERMID,
        SYSTEMROLEID,
        RECORDSECURITYMODE,    
        SITESECURITYMODE
    from 
        dbo.V_SECURITY_SYSTEMROLEASSIGNMENT_USER_SMARTQUERY_BYROLE
        with (NOEXPAND, INDEX(IX_V_SECURITY_SYSTEMROLEASSIGNMENT_USER_SMARTQUERY_BYROLE_SMARTQUERYCATALOGID_APPUSERID))
    union all
    select
        SMARTQUERYCATALOGID,
        APPUSERID,
        GRANTORDENY,
        PERMID,
        SYSTEMROLEID,
        RECORDSECURITYMODE,    
        SITESECURITYMODE
    from 
        dbo.V_SECURITY_SYSTEMROLEASSIGNMENT_USER_SMARTQUERY_BYFEATUREGROUP
        with (NOEXPAND, INDEX(IX_V_SECURITY_SYSTEMROLEASSIGNMENT_USER_SMARTQUERY_BYFEATUREGROUP_SMARTQUERYCATALOGID_APPUSERID));