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

From: bruce <bedouglas_at_earthlink.net>
Date: 2006-06-19 16:13:54 CEST

jason...

does your app allow for users to request that they be added to a given
area/part of the workflow...

how will you deal with users who want to dynamically change the folders of
the workflow that they have access to.

example:
 foo.txt is placed in dev folder

 sue wants access to the development folder (foo.txt)
 bob wants access to the testing folder (foo.txt)

 sue modifies foo.txt, and moves it to testing

 bob completes testing of foo.txt and moves file
 to production

 the app should now delete/remove sue/bob from
 the user file access file...

does the subversion API allow you to more or less intercept/redirect the
user file access process...

-bruce

-----Original Message-----
From: jason@subversus.org [mailto:jason@subversus.org]
Sent: Monday, June 19, 2006 6:42 AM
To: bedouglas@earthlink.net; users@subversion.tigris.org
Subject: RE: User File Access from Mysql DB...

While your example is kind of vague, it sounds like you need to utilize the
API to Subversion and possibly have a MySQL database back end. Such an
example would be an application (possibly web-based?) that acts as an
interface to Subversion (in which the files would be stored) and the
work-flow data stored in some form of a database.

I'm currently implementing a similar type of system... a document management
/ approval system that is based on top of Subversion / SQL Server. The
documents are uploaded and stored in Subversion, the document settings and
data are stored in SQL Server. The interface is a web application in which
individuals can view and approve the documents based on permissions.

-----Original Message-----
From: bruce [mailto:bedouglas@earthlink.net]
Sent: Monday, June 19, 2006 9:25 AM
To: users@subversion.tigris.org
Subject: User File Access from Mysql DB...

hi...

i'm considering Subversion as a reopistory, but i need the ability to
implement the SVN system in a workflow kind of application. this requires
that as a file goes from one part of the process to another, the user
assigned to that part of the process will have access to only the files in
that part of the process...

i also need to accommodate the fact that users can/might be switched to
different parts of the process.

i've considered keeping all this information in a mysql db, and then somehow
writing out the subversion user access file whenever a change is made to the
overall access system... this seems to be a good chunk of development, and
i'm not sure if it's the right thing to do..

i've also considered the possibility of having to rewrite subversion to have
it get the user file access rights information from a database.. but i'm not
sure if this is the best approach...

any thoughts/ideas/comments from people who are really familiar with
subversion? has anyone else run into this kind of need...

the issue basically boils down to how you can use subversion in a system
where the users and files are dynamically changing...

thanks

-bruce
bedouglas@earthlink.net

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@subversion.tigris.org
For additional commands, e-mail: users-help@subversion.tigris.org

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@subversion.tigris.org
For additional commands, e-mail: users-help@subversion.tigris.org

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@subversion.tigris.org
For additional commands, e-mail: users-help@subversion.tigris.org
Received on Mon Jun 19 16:12:44 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.