As
caillte pointed out, using a database is really the only
way to go. CSV files, DBM files, or plain-text files of any
variety are very easy to hack around with, but they are hard
to scale, especiaally under a deadline. Unless you're doing
a five minute hack that will be used only once or twice,
it is best to do it properly the first time, which once you
get used to it isn't that much harder anyway.
There are DBD (Database Drivers) for Perl for nearly every
DB that you can think of, and a few you probably wouldn't
want to. Informix, Oracle, MySQL, ODBC, Solid, Interbase,
the list
is pretty large, so you can pick whatever you have access to.
MySQL is good because
it is Open Source, and runs just as well on NT as it does
on UNIX. You can even purchase a support contract on it,
which is an important factor when trying to convince IT
to use it.
Regarding "unprivileged users", this is easy to implement
using a database as a conduit to pass information:
Web <---> CGI <---> SQL <---> "Priviledged"
User App DB Process
The CGI can handle login access verification and basic
security. The "Priviledged" process can handle the actual
special work, taking its command from the configuration in
the database. You can add extra security by using
SSL,
restricting access to the CGI application itself, and more.
The system user that runs the Web server (i.e. 'nobody')
just needs read/write access to the SQL database, and
you can even limit that further using SQL access control
methods (i.e. 'SELECT' and 'UPDATE' but not 'INSERT')
The configuration is managed from a central database, so
the process itself can read and re-read its config from
this database on demand, or on a regular schedule.
For simplicity, if you
tie the DB to a hash,
merely putting stuff in the hash in one program,
will make it instantly available to another using the same
table. If you are new to SQL, this is by far the easiest
way to get going.