[consulting] multisite with shared users, but with different roles

[Laura Scott]

[I posted this on the support list, but given the mission of the  
consultants' list, perhaps it's a good one to post here, as it gets  
to architecture, a current project and best practices on a current  
problem....]

I am working on a multisite-type of project involving over a dozen  
sub-sites. The main site will have accumulated content (and I assume  
I'll use agg2 for that, though I'm not 100% sure that's the best or  
easiest way) and the sub-sites will have their own content, own  
admins, own bloggers, etc.

Ideally, people could register on one site and be registered for all  
sites. But they would have user roles only as appropriate for the  
site they're on. In other words, someone on Site A with blogging  
permissions is also registered on Sites B, C, D... but without  
blogging permissions. Same with admins.

I am contemplating a multisite install with:

shared tables
- users
- profile
- ?

unique tables per site
- users_roles
- roles
...and everything else

Questions: Am I looking for trouble going this way? Are there other  
tables I will need to share (e.g., sessions, cache)? Are there other  
pitfalls to this hybrid multisite approach I should watch out for?

Can you suggest alternative approaches you might try? (I'm looking at  
SXIP, but it seems to be overkill for what we're after.)

Any insights, experiences, warnings, anecdotes appreciated! Thanks!

Laura



Laura Scott
President
laura at pingv.com

pingVision, LLC
4450 Arapahoe Ave, Suite 100
Boulder, CO 80303
www.pingv.com
303.415.2559


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/consulting/attachments/20060315/71c4e43d/attachment-0001.htm