Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kamal.A
Yak Posting Veteran
70 Posts |
 Posted - 2009-02-02 : 13:15:16
|
| Hi All,I'm new for DB design. I need to design a DB table for the following information.1. User table - stored all the user information.2. Menu table - list of menus are stored.3. Role table - List of roles are stored based on the menus.4. Role rights - List of roles and page rights are stored.I'm using the above tables to set the user menu loading for different types of users. but it is not a strong method. So pls give a sample table and fields for my reference.Thank you. |
|
|
saurabhsrivastava
Posting Yak Master
216 Posts |
Posted - 2009-02-02 : 13:58:51
|
| do a google search as no one has time to design complete database and once you are done with design we can suggest best practices or redirect you to different blogs/posts/whitepapers |
 |
|
|
|
|
|
DB schema design