CREATE PROCEDURE dbo.[Forum_Permissions_GetForum]
    @ForumPermissionID INT
AS
    SELECT  F.[ForumPermissionID],
            F.[ForumID],
            P.[PermissionID],
            F.[RoleID],
            CASE F.RoleID
              WHEN -1 THEN 'All Users'
              WHEN -2 THEN 'Superuser'
              WHEN -3 THEN 'Unauthenticated Users'
              ELSE R.RoleName
            END 'RoleName',
            F.[AllowAccess],
            P.[PermissionCode],
            P.[PermissionKey],
            P.[PermissionName]
    FROM    dbo.Forum_ForumPermission F
            LEFT JOIN dbo.Forum_Permission P ON F.PermissionID = P.PermissionID
            LEFT JOIN dbo.Roles R ON F.RoleID = R.RoleID
    WHERE   F.ForumPermissionID = @ForumPermissionID

GO