Table design for Login

Question

0.00/5 (No votes)

See more:

I'm creating a login page in windows form using C#.net. As usual two labels, two textboxes for username and password. two buttons for login and cancel
Have done with design level, I want to create a table in database for this login, what are the basic field I should include in that table for the Login function like username,password, roles,etc

Posted 4-Aug-11 20:47pm

CyborgForever

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

walterhevedeich · Answer 1 · 2011-08-04T20:52:00

Applications usually vary but here is what I am putting on my UserInfo table.

UserID
UserName
EmailAddress
Password -- this should be at least hashed on the application side
RoleID -- a foreign key to the roles table
FirstName
LastName
DateOfBirth
...etc

There might be instances where you want to separate the user info to another table and your username and password to another table.