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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.