HOW TO CREATE A NEW USER IN ORACLE DATABASE SYSTEM?

Creating New User

Hello Everyone!

Today we are going to discuss about how we can create a new user in oracle database.

> First of all, we need to connect in the system of the database.

SQL> conn sys as sysdba

Press Enter 2 times.

> Then we can create a new USER with our desire name. Here I'm going to create a new user named   "newuser"

SQL> create user newuser(username) identified by user(password);

press enter

That's enough to create a new user in your database. 

Thanks for being with me.

Bye