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

Hi,

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.

Greetings,
        Jörg

-- 
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