Setting up Oracle Database on Oracle VM VirtualBox is a great way to practice database management in a controlled environment. In this guide, we’ll walk through how to create a new user, assign roles, and log in with the new credentials inside your Oracle Database.

Step 1: Checking for Version Number

Run the following command in SQL*Plus to check the version number:

Step 2: Create a New User

Start by connecting to your Oracle Database as SYSDBA. Once connected, use the following SQL command to create a new user:

Explanation:

• C##free → the username (the prefix C## is required for common users in a multitenant database).

• IDENTIFIED BY free → sets the initial password.

• DEFAULT TABLESPACE users → assigns the user to the users tablespace.

• QUOTA UNLIMITED ON users → allows unlimited space in that tablespace.

• PASSWORD EXPIRE → forces the user to change the password upon first login.

 Step 6: Verification

To verify your user setup, try creating a simple table:

CREATE TABLE sample_table (

    id NUMBER PRIMARY KEY, 

    name VARCHAR(50)

);

If this executes successfully, your user setup and configuration are complete.

Summary

In this setup, you:

1. Verified the Oracle Database version.

2. Created a new common user and role.

3. Granted essential privileges and connection access.

4. Logged in and set a new password successfully.

You’re now ready to explore Oracle SQL under your new user account in VirtualBox!