CREATE VIEW dbo.[Forum_vw_ForumPermissions]
AS  SELECT  FP.ForumPermissionID,
            FP.ForumID,
            P.PermissionID,
            FP.RoleID,
            CASE FP.RoleID
              WHEN -1 THEN 'All Users'
              WHEN -2 THEN 'Superuser'
              WHEN -3 THEN 'Unauthenticated Users'
              ELSE R.RoleName
            END AS RoleName,
            FP.AllowAccess,
            FP.UserID,
            U.Username,
            U.DisplayName,
            P.PermissionCode,
            P.PermissionKey,
            P.PermissionName
    FROM    dbo.Forum_ForumPermission AS FP
            LEFT OUTER JOIN dbo.Forum_Permission AS P ON FP.PermissionID = P.PermissionID
            LEFT OUTER JOIN dbo.Roles AS R ON FP.RoleID = R.RoleID
            LEFT OUTER JOIN dbo.Users AS U ON FP.UserID = U.UserID

GO