Oracle Tutorials: How to add additional user and grant his access in Oracle

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 Rajesh Kumar, a DevOps, SRE, DevSecOps, Cloud, and Platform Engineering expert passionate about sharing practical knowledge, real-world experiences, and industry best practices. I have worked at Cotocus and regularly write about technology, travel, investing, health, product reviews, and digital marketing through my various platforms.

I publish technical articles at DevOps School, travel stories at Holiday Landmark, stock market insights at Stocks Mantra, health and fitness guidance at My Medic Plus, product reviews at TrueReviewNow, and SEO and digital marketing strategies at Wizbrand.