OK to edit UsersPortals and UsersRoles tables?

Hi John,

I'm looking at adding users from some of the child portals on our site to roles on our parent portal. After looking through the DB, it looks like the UsersPortals and the UsersRoles tables are the only ones I would need to make changes in.

Can you think of any potential problems of just:

1. adding the child portal user's UserID to a new record with the parent portal PortalID in the UsersPortals table
2. adding a record for each RoleID that the UserID is to be added to on the parent portal in the UsersRoles table

I've manually performed the above 2 steps on a local install and it seems to work just fine. I've been able to log into the parent portal as that user and have been able to go back and forth between the portals seamlessly. No problems so far.

Can you think of any potential problems with this approach? Security problems that I'm not thinking of?

Thanks for your insight,
Ari

 I've looked in the aspnet_ tables and I don't find any columns having to do with portals or roles. So hopefully I won't have to mess with them.

 I honestly still don't know if it is all this easy... That's why I'm asking

Of interest here, I did by the DNNMasters "Multi-Portal User Sharing Extreme" module for this purpose. I was really hoping that a COTS module would do it. Unfortunately, it has so many bugs and security problems that I am looking at how I might accomplish it with a simple custom module instead. I just can't risk security problems b/w portals.

PLEASE NOTE: They are working on fixing the problems I encountered. So, they at least get a positive review for that.

I wonder if the dnnmasters folks might know something I don't about the DNN portals, roles, and users? The dnnmasters module is really complex. It even replaces the core dnn membership provider and requires big web.config changes to do it.

So, again, maybe they know something I don't?

I don't have any experience with DNN 4.6+ yet. DNN added membership providers, like LiveID somewhere along the way. Do you know if these changes break what I've done? (or maybe I should install dnn 4.8.1, make a log-in with a standard dnn login and a LiveID and see what the db tables look like)

I hope that's all it is. I hope the complexity only has to do with the fact that it works for multiple versions of DNN. I'd hate to think I was missing something really important here...

The dnnmasters portal user sharing module doesn't do import, export and adding new users, AFAIK. They sell an other module for those things.