@MyWaterloo
I would have to concur with Stewart and Linq, this is not a good idea for multiple reasons, mainly, users usually have very little regard for database normalization and design, so they are more likely to make your database a design nightmare instead of making it easier on you.
Besides, no offense, but designing and redesigning a DB is the DBA's job, I work at a place that in the past they allowed "users" to design their own fields and even entire tables, we now have a table with 157 million records in it and ZERO indexes, for those who understand databases, that ain't good.
I hope you decide to keep this job in your hands, besides, it's job security =)
-AJ