V_SECURITY_SYSTEMROLEASSIGNMENT_USER_SELECTION

Fields

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

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_V_SECURITY_SYSTEMROLEASSIGNMENT_USER_SELECTION_SELECTIONID_APPUSERID	SELECTIONID, APPUSERID
IX_V_SECURITY_SYSTEMROLEASSIGNMENT_USER_SELECTION	APPUSERID, PERMID	yes		yes

Definition

Copy


                CREATE view [dbo].[V_SECURITY_SYSTEMROLEASSIGNMENT_USER_SELECTION] with SCHEMABINDING
            /*Indexed view used to evaluate Record Access Security for selections
            Includes a row for every system role/user/selection permission that has been assigned.
            */
            as
            select 
                SYSTEMROLEPERM_SELECTION.SELECTIONID,
                SYSTEMROLEAPPUSER.APPUSERID,
                SYSTEMROLEPERM_SELECTION.GRANTORDENY,
                SYSTEMROLEPERM_SELECTION.ID as PERMID,
                SYSTEMROLEPERM_SELECTION.SYSTEMROLEID,
                SYSTEMROLEAPPUSER.CONSTITUENTSECURITYMODECODE as RECORDSECURITYMODE,
                SYSTEMROLEAPPUSER.SECURITYMODECODE as SITESECURITYMODE
            from 
                dbo.SYSTEMROLEPERM_SELECTION 
                inner join dbo.SYSTEMROLE on SYSTEMROLEPERM_SELECTION.SYSTEMROLEID = SYSTEMROLE.ID
                inner join dbo.SYSTEMROLEAPPUSER on SYSTEMROLEPERM_SELECTION.SYSTEMROLEID = SYSTEMROLEAPPUSER.SYSTEMROLEID