Thanks for the ideas. Bruno has reminded me that 'multi-tenant' is a better description than 'multi-company'.
@B GAE namespacesAPI looks like it might be an interesting solution to build into DAL. I think Massimo would quickly know how feasible that was. http://code.google.com/appengine/docs/python/multitenancy/ @M I think the multi-DB solution is fairly straight-forward for sqlite, but perhaps a little tricky setting up and managing bigger production DBs. I can see that the physical separation of DBs may be desirable for separate company accounting systems, but I cannot think of enough good reasons to justify this complication for my case. Of course the ultimate size of a multi-tenant DB might be huge and slow things down, but that is not my concern. @A I think your standardised groups will simplify things. However, there is then some sacrifice of fine-tuning permissions. I believe I shall try the company_id solution with standardized auth_groups. Regards, D
