Following are the commands to create new user in Oracle database.
1. You have to log in to the oracle command window. In command prompt enter below command.
Syntax : sqlplus sys/DB_password@Database as sysdba;
Ex : sqlplus sys/password@orcl as sysdba;
2. Create user New_User_Name identified by password account unlock;
3. grant connect to New_User_Name;
4. grant create session, dba to New_User_Name;