Applying passwords to users

I have created a database with access via a front page using a user login.
The database has 3 levels of access according to user login. I need to apply password to each login.
How do I achieve this ?
thanks