Manually Create a Primary User

The procedure for manually creating the Oracle primary user is similar to that for creating a schema owner (see the previous section).

To manually create an Oracle primary user

If you have not already done so, copy the following files to a local folder:
- CreateOracleUser.sql
- WgnSetupOwner.sql
Find these files in the \Support folder of your CA DataMinder distribution image.
From a command line, change to the folder that you chose in step 1. Then run this command:
```
sqlplusw 
```
This launches the Oracle SQL*Plus utility and sets the correct working directory for the script execution.
In SQL*Plus, connect to the CA DataMinder database as a user with sysdba privileges.
Run the following command:
```
@CreateOracleUser
```
The script prompts you for the following details:
1. Enter a user name and password for the new user. You must supply these credentials when you install a CMS or gateway.
2. Enter an existing tablespace. See also the recommendation in Tablespaces for CA DataMinder.
Finally, the script outputs a summary of the new account.
If you want to change the password or tablespace, rerun the script now.
Important! You cannot change the password or tablespace after you have installed the CMS!

More information: