V_SECURITY_SYSTEMROLEASSIGNMENT_USER_ATTRIBUTECATEGORY

Fields

Field	Field Type	Null	Description
ATTRIBUTECATEGORYID	uniqueidentifier
APPUSERID	uniqueidentifier
PERMID	uniqueidentifier
SYSTEMROLEID	uniqueidentifier

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_V_SECURITY_SYSTEMROLEASSIGNMENT_USER_ATTRIBUTECATEGORY	APPUSERID, PERMID	yes		yes

Definition

Copy


                CREATE view [dbo].[V_SECURITY_SYSTEMROLEASSIGNMENT_USER_ATTRIBUTECATEGORY] with SCHEMABINDING
                AS

                select
                    SRP.ATTRIBUTECATEGORYID,
                    SRAU.APPUSERID ,
                    SRP.ID AS [PERMID],
                    SRP.SYSTEMROLEID

                from
                    dbo.SYSTEMROLEPERM_ATTRIBUTECATEGORY SRP
                inner join dbo.SYSTEMROLE as SR on 
                    SRP.SYSTEMROLEID=SR.ID
                inner join dbo.SYSTEMROLEAPPUSER as
                    SRAU on SRP.SYSTEMROLEID=SRAU.SYSTEMROLEID