Create the Install User in Oracle Argus Mart

Note:

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

To create an Install user that has privileges same as the SYSTEM user for installation:

1. Execute the following script from the folder DBInstaller\Utilities\Create_Dba_User:
   • For Windows—Use the batch script am_create_dba_user.bat
   • For Linux—Use the shell script am_create_dba_user
2. When prompted, enter the following parameters:
   • Oracle Argus Mart Database instance name
   • SYS or an equivalent SYSDBA user on this database
   • SYSDBA user password
   • Name of the Install User—For example, AM_DBA_USER
   • Install 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:

   Install User created.

3. Verify the status from the log file.

   C:\Program Files (x86)\Oracle\ArgusMart\Database\DBInstaller\Utilities\Create_Dba_User\am_dba_user_ mmddyyyy_hh24miss.log

4. Press Exit.

Note:

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

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

DROP USER <INSTALL_USER> CASCADE;