Revision as of 18:14, 8 October 2008

Accountability

If accountability is a concern, there are a few more things you'll want to add to your database schema. In particular, a last_modified time (and optionally a last_editor) column on some of the tables to indicate when (and by whom) the last modifications were done. At the very least, the configuration/server tables should probably have this information. You may also want to add them to the configuration_* tables to indicate the changes that were made.

Also, will you need a security table to store authorized users (and passwords) which will grant people access to the modification abilities? You may also consider a simple audit_trail table, which contains a list of users, times, and actions performed using the web-based tool. You may have already designed this table, and have not displayed it for security reasons. Other alternatives would require linking this tool in with an existing security module, like a web or wiki login.

Again, if accountability is not a concern (now or ever), you can disregard this comment.

-- Thraxian 13:51, 7 October 2008 (UTC)

Thanks for your comments. I added the authorization and logging part. Didnt have time for that. Please comment on the design v0,02