View Single Post
  #6 (permalink)  
Old January 6th, 2009, 12:33 PM
dparsons dparsons is offline
Wrox Author
Points: 13,255, Level: 49
Points: 13,255, Level: 49 Points: 13,255, Level: 49 Points: 13,255, Level: 49
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Oct 2005
Location: Ohio, USA
Posts: 4,104
Thanks: 1
Thanked 64 Times in 64 Posts
Send a message via AIM to dparsons
Default

Hmmm. There is a myriad of ways to assign permissions to tables, how you do it is going to be up to you but this sounds like the making of a management nightmare. Since there is a 1:1 correlation between users and tables, you will have to create a table for every single user and, depending on how many potential users you have, the management of said tables becomes unwieldy. I would probably use a single database table for all users and then filter the data coming out of said table based on a given user.

I can not honestly think of a good secnario where I would want each website user to have their own single table in my database.

hth.
-Doug
__________________
===============================================
Doug Parsons
Wrox online library: Wrox Books 24 x 7
Did someone here help you? Click on their post!
"Easy is the path to wisdom for those not blinded by themselves."
===============================================