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

[Bèr Kessels]

Hi,
sharing tables has a lot of downsides. I think you will like sqlauth for your 
project. AFAIKS it is the ideal tool to get yourself rolling.

Esp if you apply the patch that allows "remote" users without @server. 

I have got some drupal sites, with that patch and sqlauth to work completely 
transparant wrt user authentication.

Bèr


Op woensdag 15 maart 2006 23:15, schreef 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