On Sep 29, 2005, at 8:46 AM, Eugeny N Dzhurinsky wrote:
On Thu, Sep 29, 2005 at 08:39:53AM -0400, George Abraham wrote:
Eugene,
You could grab all the fields for a record in a SQL database, mash
it all
together and transfer it into one indexing field in Lucene. Use some
scripting tools (or even JDBC and Java) to do this. However if you
are
asking if Lucene can go and look over a SQL database and return
results,
that would not work. Lucene has to index the database fields
first. The
indexing would happen with the first two sentences of my post.
Integersting. We have some kind of set of privileges, required to
access the
object (let's say rows in table(s)), I thought if it is possible to
use
kind of "injection" of access control statement to SQL query for
extraction
of only allowed data... But if Lucene needs to index anything, how
could I
define the access privileges for data?
There are many options available. One such technique I described in
"Lucene in Action" ... a SecurityFilter. This simple example scheme
assumes each document has an "owner" and only owners are allowed to
see their documents and no others. By applying a SecurityFilter on a
search, the results are constrained appropriately. This scheme is
intentionally simplistic to show the possibilities. More commonly
would be a situation with users and groups that need to be
dynamically configurable - a Filter could still do this sort of
thing, but how documents are associated with groups would need to be
thoroughly conceived.
Erik
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]