Uncategorised

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

May 2, 2023 Leave a Comment 
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.
Rajesh Kumar
Follow me
Latest posts by Rajesh Kumar (see all)
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x