I want to set up user access to a database. The user's access is limited, but I would like for them to be able to create a password for entry. The time will come where the user forgets their password. How does an administrator go about recovering that password for the user?
You never do. Instead, you change their password to a new one. You can give it a default value such as the same as their account name and set their account to require them to enter a new password the next time they log in.