"Jay F. Davis" a écrit :
in a multi-user configuration, how can you put the relationtable in a central db? Did you add a 'user' field? Do you let users modify the relationtable?
Unless I'm misunderstanding the question, the appropriate place to manage user permissions is within MySQL. You grant select access to the relations table for everyone, but only the administrator gets access to UPDATE the relations table.
Jay,
In a multi-user system, each developer must be able to update his relationtable (or if the relationtable becomes central, his part of the relation table). You let each developer manage his tables, so I think this should be the same for the relationtable.