Hi, Do you have any kind of "group" membership for you users? If you have, a resource's list of security access tokens could be smaller and avoid re-indexing most resources when adding "normal" users which mostly belong to groups. The common way is to add filters on the query. You may do it yourself or have some framework/plugin to it for you, see http://wiki.apache.org/solr/SolrSecurity#Document_Level_Security
-- Jan Høydahl, search solution architect Cominvent AS - www.cominvent.com Solr Training - www.solrtraining.com On 23. jan. 2012, at 11:49, John, Phil (CSS) wrote: > Hi, > > > > We're building quite a large shared index of resources, using Solr. The > application that makes use of these resources is a multitenant one > (i.e., many customers using the same index). For resources that are > "private" to a customer, it's fairly easy to tag a document with their > customer ID and using a FilterQuery to limit results to just their > "stuff". > > > > We are soon going to be adding a large number (many tens of millions) of > records that will be shared amongst customers. Not all customers will > have access to the same shared resources, e.g.: > > > > * Shared resource 1: > > o Customer 1 > > o Customer 3 > > > > * Shared resource 2: > > o Customer 2 > > o Customer 1 > > > > The issue is, what is the best way to model this in Solr? Should we have > multiple customer_id fields on each record, and then use the filter > query as with "private" resources, or is there a better way of doing it? > What happens if we need to do a bulk change - i.e. adding new customer, > or a previous customer has a large change in what shared resources they > have access to? Am I right in thinking that we'd need to go through > every shared resource, read it, make the required change, and reindex > it? > > > > I'm wondering if there's a way, instead of updating these resources > directly, I could construct a set of documents that would act as a > filter at query time of which shared resources to return? > > > > Kind regards, > > > > Phil John > > Technical Lead, Capita Software Services > > Knights Court, Solihull Parkway > > Birmingham Business Park B37 7YB > > Office: 0870 400 5000 > > Fax: 0870 400 5001 > email: philj...@capita.co.uk <mailto:philj...@capita.co.uk> > > > > Part of Capita plc www.capita.co.uk <http://www.capita.co.uk> > > > > > > This email and any attachment to it are confidential. Unless you are the > intended recipient, you may not use, copy or disclose either the message or > any information contained in the message. If you are not the intended > recipient, you should delete this email and notify the sender immediately. > > Any views or opinions expressed in this email are those of the sender only, > unless otherwise stated. All copyright in any Capita material in this email > is reserved. > > All emails, incoming and outgoing, may be recorded by Capita and monitored > for legitimate business purposes. > > Capita exclude all liability for any loss or damage arising or resulting from > the receipt, use or transmission of this email to the fullest extent > permitted by law.