Maps all DNN Users to a portal

map-users-to-portal.sql

DECLARE @UserId int
DECLARE @PortalId int
SET @PortalId = 6 -- <<<< Adjust to your portal ID
DECLARE @Authorized bit
SET @Authorized = 0 -- <<<< Adjust if you want the users to be authorized or not

DECLARE MY_CURSOR CURSOR
	LOCAL STATIC READ_ONLY FORWARD_ONLY
FOR
SELECT DISTINCT UserID
FROM Users

OPEN MY_CURSOR
FETCH NEXT FROM MY_CURSOR INTO @UserId
WHILE  @@FETCH_STATUS = 0
BEGIN
	-- Map user to portal
	IF not exists ( SELECT 1 FROM dbo.UserPortals WHERE UserID = @UserID AND PortalID = @PortalID ) AND @PortalID > -1
		BEGIN
			INSERT INTO dbo.UserPortals (
				UserID,
				PortalID,
				Authorised,
				CreatedDate
			)
			VALUES (
				@UserID,
				@PortalID,
				@Authorized,
				getdate()
			)
		END
	-- End Map user to portal
	PRINT @UserId
	FETCH NEXT FROM MY_CURSOR INTO @UserId
END
CLOSE MY_CURSOR
DEALLOCATE MY_CURSOR