Here are the steps to add an additional user and grant them access in Oracle:

Connect to the database as a user with administrative privileges, such as SYS or SYSTEM:

$ sqlplus sys/<password> as sysdba
Replace <password> with the password for the SYS or SYSTEM user.

Create a new user using the CREATE USER command:
$ CREATE USER <username> IDENTIFIED BY <password>;

Replace <username> with the name of the new user and <password> with their password.

Grant privileges to the new user using the GRANT command. For example, to grant the user privileges to create tables and insert data into them:

$ GRANT CREATE TABLE, INSERT ANY TABLE TO <username>;

You can grant any privileges that the user needs to perform their job.

Optionally, create a new role and assign it to the new user using the CREATE ROLE and GRANT ROLE commands. For example:

$ CREATE ROLE <role_name>;
$ GRANT <role_name> TO <username>;

You can add privileges to the role using the GRANT command, then assign the role to any additional users as needed.

Verify that the user can log in to the database by connecting as the new user:

$ sqlplus <username>/<password>

Exit SQL*Plus when you are done:
$ exit

That's it! You have added a new user and granted them the necessary privileges to work in the database.






Code language: PHP (php)

Rajesh Kumar

I’m a DevOps/SRE/DevSecOps/Cloud Expert passionate about sharing knowledge and experiences. I have worked at Cotocus. I share tech blog at DevOps School, travel stories at Holiday Landmark, stock market tips at Stocks Mantra, health and fitness guidance at My Medic Plus, product reviews at TrueReviewNow , and SEO strategies at Wizbrand.

Do you want to learn Quantum Computing?

Please find my social handles as below;

Rajesh Kumar Personal Website
Rajesh Kumar at YOUTUBE
Rajesh Kumar at INSTAGRAM
Rajesh Kumar at X
Rajesh Kumar at FACEBOOK
Rajesh Kumar at LINKEDIN
Rajesh Kumar at WIZBRAND

Rajesh Kumar DailyLogs