Create the DBA User

Note:

You must execute this script to install Oracle Argus Insight database, even if you are using the SYSTEM user. This script provides additional grants to the existing user.

To create a DBA user that has privileges same as the SYSTEM user for installation:

1. Execute the following script from the folder Argus Release Media\Database\ArgusInsight\Utilities\Create_Dba_User:
   • For Windows—Use the batch script ai_create_dba_user.bat
   • For Linux—Use the shell script ai_create_dba_user
   A prompt appears as Do you want to use SYSDBA to run the script? (Y/N):. Enter Y to run as SYSDBA.
2. When prompted, enter the following parameters:
   • Oracle Argus Insight Database instance name
   • SYS or an equivalent SYSDBA user on this database
   • SYSDBA user password
   • Name of the DBA User—For example, AI_DBA_USER
   • DBA user password

   If you provide a non-existing user name, then the script creates this as a new user, and provides the necessary grants to this user.

   If you provide an already existing user name, then the script provides the necessary additional grants to the existing user.

   When done, a message appears as:

   Created DBA user &dba_user

3. Press Exit.
4. Verify the log files for status information from:

   Argus Release Media\Database\ArgusInsight\Utilities\Create_Dba_User\AI_DBA_User_ MMDDYYYY_HH24MISS.log

Note:

For security reasons, Oracle recommends to drop the DBA user from the database after successful installation of Oracle Argus Insight as this user will have DBA privileges.

To drop this user, connect to the respective database as a privileged user, and execute the following command:

DROP USER <INSTALL_USER> CASCADE;