To Create a Database User

To create a database user, use the sqlplus utility.

1. Become superuser by issuing the following command:

   su - oracle

2. Start the sqlplus utility:

   sqlplus /nolog

3. At the prompt, connect to the database:

   sqlplus>connect / as sysdba

4. Create a user and specify the password for the user:

   sqlplus>create user user-name identified by password;

   The password value must be at least six characters.

   For example, to specify a user named APP and a password of app123, you would use the following command:

   sqlplus>create user APP identified by app123;

5. Grant privileges to the user you created:

   sqlplus>grant connect, resource, dba to APP;

6. Exit the utility:

   exit