• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 279
  • Last Modified:

login Database in SQL

Hello, I simply want to create a user login database in SQL, what details or Keys should I need  beside the obvious username and password... and how do I create it in the server management studio
0
jhonc66
Asked:
jhonc66
1 Solution
 
Kent DyerIT Security Analyst SeniorCommented:
Index key for an ID..  Login created, Status (e.g. Active, Disabled, Deleted, Lockout), Date Locked, Date Disabled.

Be very careful with password.  It would be recommended to HASH or otherwise encrypt the password field as this can be a security audit issue.

This should get you started.

HTH,

Kent
0
 
Steve WalesSenior Database AdministratorCommented:
In Management Studio there's a Security branch off the main tree.  Expand that, right click on Logins and then New.

Fill in the blanks from there and away you go.
0

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now