Create User in Oracle Database using Database Administration Settings

You can also create a new user in Oracle Database using Oracle database administration settings.

Follow the following steps in Oracle database administration settings to create user in Oracle database.

Step 1. Login into your oracle database.

Step 2. Go to administration option and then go to database user option now database users is appear as shown.

Step 3. Click on the create option present on right side. As you see create database user window now create new user and set password for that user.

Step 4. Type username as you want and password for that username. confirm the password and if you want that  password is expired after some time so than you can change it so you can check the expire password box .you can also set account status lock/unlock according to privacy and give the role and privileges according to the user.

Step 5. After completion click on create option .Now you get a confirmation message that user is created in your database and you can also see that new user ‘Newgeeks’ is added in the list as shown.

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.