[dbo].[Forum_Permissions

[dbo].[Forum_Permissions_AddForum]

(local) > DotNetNuke_Community > Stored Procedures > dbo.Forum_Permissions_AddForum

Property	Value
ANSI Nulls On
Quoted Identifier On

Name	Data Type	Max Length (Bytes)
@ForumID	int	4
@PermissionID	int	4
@RoleID	int	4
@AllowAccess	bit	1
@UserID	int	4

CREATE PROCEDURE dbo.[Forum_Permissions_AddForum]
    @ForumID INT,
    @PermissionID INT,
    @RoleID INT,
    @AllowAccess BIT,
    @UserID INT
AS
    INSERT  INTO dbo.Forum_ForumPermission
            (
              [ForumID],
              [PermissionID],
              [RoleID],
              [AllowAccess],
              [UserID]
            )
    VALUES  (
              @ForumID,
              @PermissionID,
              @RoleID,
              @AllowAccess,
              @UserID
            )

    SELECT  SCOPE_IDENTITY()

GO