When you say User are you talking about the Editor User for the bubble app OR do you mean a User within User Table records?

If it’s the second; then you need to set up a workflow for that user. Put a reset button on any page, search for the email, use the “temporary password” action and email it to the user. You can now log in with that temporary password.