For those who want to automatically share users between portals without using the GUI, check out the trigger below.
How does it work? When a user is inserted or updated, the trigger will add (userid, portalid) to table UserPortals for all portals.
To apply the tigger, log in as Host and go to Host -> SQL. Paste the code, check Run as Script, and then click on Execute.
-- =============================================
-- Author: Fuji Nguyen
-- Create date: 6/12/07
-- Description: Trigger to add userid, portalid to UserPortals table to enable single account to access all parent/child portals
-- =============================================
CREATE TRIGGER trig_User_Multiportal
ON dbo.Users
AFTER INSERT, UPDATE
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
DECLARE @UserID int
-- Insert statements for trigger here
SELECT @UserID = UserID FROM INSERTED
INSERT INTO UserPortals
(
UserId,
PortalId
)
SELECT
@UserId AS UserID,
PortalId
FROM Portals
WHERE PortalID NOT IN (SELECT PortalID FROM UserPortals WHERE UserID = @UserID)
END
GO