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

UserID	Username	FirstName	LastName
1	host	SuperUser	Account
2	admin	Admin	Istrator
3	test	test	test
4	ACKE02	ALLEN	ACKERMANN
5	ADAM10	BRANDT	ADAMS
6	ADAM08	PHILLIP	ADAMS
7	NGUY01	D. FUJI	NGUYEN
8	testtest	testteste	est
9	alan0	Alan	Brewer

Table 2 -  Sample data from the Roles table

RoleID	PortalID	RoleName	Description
0	0	Administrators	Portal Administration
1	0	Registered Users	Registered Users
2	0	Subscribers	A public role for portal subscriptions
3	0	TimeXP	TimeXP
7	2	Administrators	Portal Administration
8	2	Registered Users	Registered Users
9	2	Subscribers	A public role for portal subscriptions

Table 3 - Sample data from the UserRoles table

UserRoleID	UserID	RoleID
1	2	1
2	2	2
3	2	0
5	3	1
6	3	2
7	3	3
8	4	1
9	4	2
10	5	1
11	5	2
12	6	1
13	6	2
17	2	8
18	2	9
19	2	7
20	7	1
21	7	2
22	8	1
23	8	2
24	9	1

Fuji.