Do you want to add or remove or update a role membership for a single user or multiple users?

---

Cheers from Germany,
Sebastian Leupold

   

Speed up your DNN Websites with TurboDNN

Hi Y Ma,
You should lookup RoleID from Roles Table - that's a bit easier than handling with RoleName and PortalID.

To assign a user to a role, you need to add a record to UserRoles table. The best option would be a Merge statement:

MERGE INTO dbo.UserRoles T
USING (SELECT @RoleID AS RoleID, UserID FROM dbo.UserPoints WHERE PointCount > 100) AS S ON T.UserID = S.UserID AND T.RoleID = S.RoleID
WHEN NOT MATCHED THEN INSERT (RoleID, UserID, Status) VALUES (S.RoleID, S.UserID, 1)

You may adopt the SELECT according to your table(s) to obtain the UserIDs to add.

Please be aware that you'll need to clear the portal cache in order for database changes to become effective.

---

Cheers from Germany,
Sebastian Leupold

   

Speed up your DNN Websites with TurboDNN