The user would probably still have a password, I have not set up an oracle cloud instance but normally you would add your ssh key and still be given a password.
If you don’t know the password you can use the passwd command to change the password for your user.