Check Created User in Oracle Database
You can check that user is created or not in your database by simply login as shown.
Here we logged in successfully with new username and password. Now you can grant the role and privileges to your new user by using GRANT command.
How to Create User in Oracle Database ?
In Oracle Database there are different types of user accounts like system, sys, hr, and many more. These user accounts are by default created by Oracle.
To create a user in the Oracle Database use the CREATE USER command.