Fuji Nguyen,

Your SQL solution is superb... I have one issue with it that I hope someone can help me with.

This creates the same user against every portal in the installation, but it does not add any security roles to the user for portals other than the one they registered on. Thus if you have a page that is only visible to registered users they will not be able to see it unless you admin their account and add the user to the registered user role.

What I would like is to add the user to all the portalID's which it already does and then add all the roles that are set to auto-assign when they add to a portal (default being "registered users" & "subscribers"... That way if they come back and unsubscribe, even if they update their account... it will not subscrive them again because it will be using the same logic that says "This user already exixts for this portal therefore do not add them".

I'm hoping someone is feeling charitable... because sadly my SQL abilities rank up there with my cooking skills... Please help!

Kind regards

Pete

Pete,

Follow the example trigger I posted and see if you can come up with the ones you need.  Give it a try and if you need help, post in this forum.

Background:  DNN security roles Administrators, Registered Users, Subscribers exist in each portal.  Table 2 has example of these built-in roles for portalid 0 and portalid 2.  The objective is to create records in table UserRoles (Table 3) for each combination of RoleID (Table 2) and UserID (Table 1).   I think you will need to add triggers to table Users and Roles.

Table 1 - Sample data from table Users

Table 2 -  Sample data from the Roles table

Table 3 - Sample data from the UserRoles table

Fuji.