Creating log/pass

I need an option where the user can create their own login and password, which is then used to enter certain pages.
I am aware that this is done through a database and I have heard that tools like SiteLock offer it.
I wonder if another option exists.