V_SECURITY_SYSTEMROLEASSIGNMENT_USER_QUERYVIEW_BYROLE
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| QUERYVIEWCATALOGID | 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_QUERYVIEW_BYROLE_QUERYVIEWCATALOGID_APPUSERID | QUERYVIEWCATALOGID, APPUSERID | |||
| IX_V_SECURITY_SYSTEMROLEASSIGNMENT_USER_QUERYVIEW_BYROLE | APPUSERID, PERMID | yes | yes |
Definition
Copy
create view [dbo].[V_SECURITY_SYSTEMROLEASSIGNMENT_USER_QUERYVIEW_BYROLE] with SCHEMABINDING
/*Indexed view used to evaluate Record Access Security in Ad-Hoc query
Includes a row for every system role/user/queyview permission that has been assigned.
*/
AS
select
SYSTEMROLEPERM_QUERYVIEW.QUERYVIEWCATALOGID,
SYSTEMROLEAPPUSER.APPUSERID ,
SYSTEMROLEPERM_QUERYVIEW.GRANTORDENY,
SYSTEMROLEPERM_QUERYVIEW.ID AS [PERMID],
SYSTEMROLEPERM_QUERYVIEW.SYSTEMROLEID,
SYSTEMROLEAPPUSER.CONSTITUENTSECURITYMODECODE as RECORDSECURITYMODE,
SYSTEMROLEAPPUSER.SECURITYMODECODE as SITESECURITYMODE
from
dbo.SYSTEMROLEPERM_QUERYVIEW
inner join dbo.SYSTEMROLE on SYSTEMROLEPERM_QUERYVIEW.SYSTEMROLEID=SYSTEMROLE.ID
inner join dbo.SYSTEMROLEAPPUSER on SYSTEMROLEPERM_QUERYVIEW.SYSTEMROLEID=SYSTEMROLEAPPUSER.SYSTEMROLEID