http://qs1969.pair.com?node_id=15409

mtomkins has asked for the wisdom of the Perl Monks concerning the following question: (cgi programming)

My task is to develop and implement a system for bug reporting on our corporate website. I have been working with a simple text database, it adds/searches/modifies/deletes via a neat little HTML interface... my problem is that there needs to be two levels of security; user and admin. The user inputs the problem they encountered, it is automatically stamped with the date it was entered as well as a key number, a priority level of 0, an "assigned to:" of "nobody" and a "fix:" of "none". Now I need a way for an administrator to get in there and modify the priority, assignment, and fix of these problems. Any help would be appreciated.

Originally posted as a Categorized Question.