[thelist] Where to Store Username and Password in SQL Tables
rudy
r937 at interlog.com
Mon Jan 27 15:06:01 CST 2003
> It seems really easy to just store the Username and Password in each
> table accordingly. Like this...
>
> But are there any pitfalls to this approach?
pitfalls? not really, it's just messier than it needs to be
i mean, think of the logon password verification logic
more twice as much code
yeah, i know, cut & paste makes that sort of thing easy
still, i prefer the simple approach
> Should I create a Users table?
ayup
and store a value in a column called Admin to differentiate between the two
types of user
if your admins don't have to have their address recorded, make sure you
allow those fields to go null
rudy
More information about the thelist
mailing list