Creating a user in Oracle SQL command line

To create a new user account in Oracle, issue the CREATEUSER command. We are going to create a user in Sqlplus command line, and we will use this user in all of our shell scripts.

To create a user, run the following command:

   SQL> create user user1 identified by Test123; 

You will get the following output:

   User created. 

Get Learning Linux Shell Scripting - Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.