[svn.haxx.se] · SVN Dev · SVN Users · SVN Org · TSVN Dev · TSVN Users · Subclipse Dev · Subclipse Users · this month's index

Re: User File Access from Mysql DB... (correction)

From: Joerg Hessdoerfer <Joerg.Hessdoerfer_at_sea-gmbh.com>
Date: 2006-06-19 21:17:21 CEST


On Monday 19 June 2006 19:30, bruce wrote:
> hi joerg...
> do you write to the ACL db/file everytime a user changes their access
> requirements regarding a given file... do you also write to the ACL db/file
> everytime a file moves from folder to folder...
> for my app, the file moves between processes, and since a user might have
> access to one process and not another.. i need to solve this.
> the only way i can see is to add/delete the users within the ACL file as
> the "file" moves along the process, which is going to require a lot of
> update hits to the ACL by my app..
> another approach would be to simply rewrite a new ACL file from a db on
> every file/process change...
> -bruce

yep, that's what we do - re-write it on every databse change. But we only do
have user's access rights changes, and we don't track individual file
locations, as they usually don't move.

Re-writing the ACL is really fast in our case - and can probably be done from
a cron job every couple of minutes. Just create some trigger file when the DB
changes, an re-generate from cron if the file exits.


Leiter Softwareentwicklung - S.E.A GmbH
Mail: joerg.hessdoerfer@sea-gmbh.com
WWW:  http://www.sea-gmbh.com
To unsubscribe, e-mail: users-unsubscribe@subversion.tigris.org
For additional commands, e-mail: users-help@subversion.tigris.org
Received on Mon Jun 19 21:18:59 2006

This is an archived mail posted to the Subversion Users mailing list.

This site is subject to the Apache Privacy Policy and the Apache Public Forum Archive Policy.