V_SECURITY_SYSTEMROLEASSIGNMENT_USER_ADHOCQUERYINSTANCEEDIT

Fields

Field	Field Type	Null	Description
ADHOCQUERYID	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_ADHOCQUERYINSTANCEEDIT_ADHOCQUERYID_APPUSERID	ADHOCQUERYID, APPUSERID
IX_V_SECURITY_SYSTEMROLEASSIGNMENT_USER_ADHOCQUERYINSTANCEEDIT	APPUSERID, PERMID	yes		yes

Definition

Copy


                create view [dbo].[V_SECURITY_SYSTEMROLEASSIGNMENT_USER_ADHOCQUERYINSTANCEEDIT] with SCHEMABINDING
                /*Indexed view used to evaluate Record Access Security in Ad-Hoc query
                Includes a row for every system role/user/adhoc query permission that has been assigned.
                */
                as
                select 
                    SYSTEMROLEPERM_ADHOCQUERYINSTANCEEDIT.ADHOCQUERYID,
                    SYSTEMROLEAPPUSER.APPUSERID,
                    SYSTEMROLEPERM_ADHOCQUERYINSTANCEEDIT.GRANTORDENY,
                    SYSTEMROLEPERM_ADHOCQUERYINSTANCEEDIT.ID as PERMID,
                    SYSTEMROLEPERM_ADHOCQUERYINSTANCEEDIT.SYSTEMROLEID,
                    SYSTEMROLEAPPUSER.CONSTITUENTSECURITYMODECODE as RECORDSECURITYMODE,
                    SYSTEMROLEAPPUSER.SECURITYMODECODE as SITESECURITYMODE
                from 
                    dbo.SYSTEMROLEPERM_ADHOCQUERYINSTANCEEDIT 
                    inner join dbo.SYSTEMROLE on SYSTEMROLEPERM_ADHOCQUERYINSTANCEEDIT.SYSTEMROLEID = SYSTEMROLE.ID
                    inner join dbo.SYSTEMROLEAPPUSER on SYSTEMROLEPERM_ADHOCQUERYINSTANCEEDIT.SYSTEMROLEID = SYSTEMROLEAPPUSER.SYSTEMROLEID