Learning Linux Shell Scripting - Second Edition

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.