[thelist] Where to Store Username and Password in SQL Tables

RUST Randal RRust at COVANSYS.com
Mon Jan 27 14:45:02 CST 2003


I have two types of users in my application: Admins and Widget
Manufacturers.  Admins have access to everything, Manufactuers can only
access their particular row in the Manufacturers table.

It seems really easy to just store the Username and Password in each
table accordingly.  Like this...

Admin_ID (Primary Key)
Admin_Name
Email
Username
Password

Manufacturer_ID
Name
Address1
City
State
Zip
Username
Password

But are there any pitfalls to this approach?  Should I create a Users
table?

----------
Randal Rust
Covansys Corp.
Columbus, OH



More information about the thelist mailing list