CREATE USER Command
You can create a new user in the Oracle database using the CREATE USER command.
Syntax
CREATE USER syntax is:
CREATE USER user_name IDENTIFIED BY password ;
Create User with CREATE USER Command Example
In this example, we have created a new user ‘Geeks’ and set password ‘Geeks123’.
Output:
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.