Sample Deployment: Install CA Business Intelligence on UNIX Using Oracle › Oracle 10g › Create a Database › Create a User

Create a User

After installing Oracle and the Oracle Client, you must create a database user and provide credentials.

To create a user

1. Log in to the new Oracle database through SQLPLUS using "system" as the user and a password that you provided when creating the database.
2. Create a user.

   For example, create the user cabi.

   For SQL, create user cabi (identified by cabi).

3. Grant permission to the user for dba and sysdba.

   For example, for SQL, grant dba,sysdba to cabi.