V_SECURITY_SYSTEMROLEASSIGNMENT_USER_CODETABLEENTRY

Fields

Field	Field Type	Null	Description
CODETABLEENTRYID	uniqueidentifier
CODETABLECATALOGID	uniqueidentifier
APPUSERID	uniqueidentifier
ISDENIED	bit
PERMID	uniqueidentifier
SYSTEMROLEID	uniqueidentifier

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_V_SECURITY_SYSTEMROLEASSIGNMENT_USER_CODETABLEENTRY_CODETABLEENTRYID_APPUSERID	CODETABLEENTRYID, APPUSERID
IX_V_SECURITY_SYSTEMROLEASSIGNMENT_USER_CODETABLEENTRY	APPUSERID, PERMID	yes		yes

Definition

Copy


                create view [dbo].[V_SECURITY_SYSTEMROLEASSIGNMENT_USER_CODETABLEENTRY] with SCHEMABINDING
                /*
                Indexed view used to evaluate Security for code table entries.
                Includes a row for every system role/user permission that has been assigned.
                */

                as

                select
                    SYSTEMROLEPERM_CODETABLEENTRY.CODETABLEENTRYID,
                    SYSTEMROLEPERM_CODETABLEENTRY.CODETABLECATALOGID,
                    SYSTEMROLEAPPUSER.APPUSERID,
                    SYSTEMROLEPERM_CODETABLEENTRY.ISDENIED,
                    SYSTEMROLEPERM_CODETABLEENTRY.ID AS [PERMID],
                    SYSTEMROLEPERM_CODETABLEENTRY.SYSTEMROLEID

                from 
                    dbo.SYSTEMROLEPERM_CODETABLEENTRY
                inner join 
                    dbo.SYSTEMROLE on SYSTEMROLEPERM_CODETABLEENTRY.SYSTEMROLEID = SYSTEMROLE.ID
                inner join 
                    dbo.SYSTEMROLEAPPUSER on SYSTEMROLEPERM_CODETABLEENTRY.SYSTEMROLEID = SYSTEMROLEAPPUSER.SYSTEMROLEID