Armin,

I would not recommend to write a trigger for that - that can cause massive problems when updating.

Just query the database, find the role IDs for Subscribers and Registered Users(which you will find in the "Roles" table - mind the PortalID to find the correct roles), and then add the roles to these users in the table "UserRoles".

Don't forget to recyle the application pool or clear the cache after the changes in the database, otherwise you won't see the changes.

Happy DNNing!
Michael

---

I agree, a onetime action should not be executed by a trigger.
simply use an insert statement like
MERGE INTO dbo.UserRoles T
USING dbo.UserPortals U ON T.UserID = U.UserID AND U.PortalID = 0 AND T.RoleID = …
WHEN NOT MATCHED THEN INSERT (UserID, RoleID, …) VALUES (U.UserID, ...)

---

Cheers from Germany,
Sebastian Leupold

   

Speed up your DNN Websites with TurboDNN