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 |
|
cesark
Posting Yak Master
215 Posts |
 Posted - 2008-06-12 : 04:52:52
|
| Is users table suitable for data such as user name and password? The context is one table in SQL 2000 Server for users data (Companies) in a Website marketplace who can access to it through a user name and password. And another table in the same database for users data (personnel of our company) who can access to our Company Intranet through a user name and password.Users table of Website marketplace registers data such as Company name, company email, address, phone number, ZIP code, tax number, activity,.. Users table of personnel of our Company registers data such as User name, Surname, Company Department, tax number, private address, private zip code, private phone, private email, Social Security Number,.. Are those two tables suitable to register also user name and password? Or I have to create another two tables to register this kind of data? Thank you,Cèsar |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-14 : 00:42:30
|
| If you put them in separate table, still need user id column in both tables to link them. |
 |
|
|
cesark
Posting Yak Master
215 Posts |
Posted - 2008-06-16 : 05:44:53
|
| Hi,About Users table of personnel of our Company, If I keep user login information in a separate table, I guess I may want in the future to store more data in that table apart of user login information, like some kind of user permissions or something similar in order to access other parts of the site if needed by some users. Could you give me an example of the more habitual additional fields used (logic and kind of data stored) in the user login information table? Users table of Website Marketplace will also need user login information in a separate table? May I need additional fields in that table? What kind of fields for ex.? I ask those questions to learn a little of background about managing logins, permissions, restrictions, etc.. in the Database and how these data are used by the applications (in my case a Website and the Intranet of our Company).Thank you |
|
|
|
|
|
|
|
|
Is Users table suitable for userName and psw data?