Security: Roles/Logins/Users

[Guest_imported]

Hi,
Im trying to setup a one person - client user only - security for a small database on SQL Server 7.0 with a VB frontend. What would be the steps in creating a simple 1 user security entry. So far ive:
1.Created a specific role for the database which has permissions on all my database objects.
2.Then ive created a valid login at the server level. This has no server role but ive assigned it to the database and then assigned it to the role i created in point 1.
3.Why then Do i need users for if ive already got a login at the server level ??? How do i use these ??
4.Also when i create a valid DSN from my ODBC manager what userID and Password do i give it ?? If i had numerous logins which one would i pick ??
thanks
jonnyjjj

 

[fluteplr]

Logins have server security, users have database security.

Map the login to a user for your database. The names can and probably should be identical.

For odbc use the login and password you created in step 2, it will sql server will assgin it to the user you created above.