Run Create DBA User Script

You must run the Create DBA User scripts to create a new DBA user or grant required privileges to the existing DBA or SYSTEM user. Use this new DBA user account when running the DBInstaller to create the Argus Safety schema.

The DBA user created by this script can perform the actions as done by the SYSTEM user. All the manual grants which used to be assigned to the SYSTEM user (prior to the Argus Safety 8.1 release), are now part of this script. The term SYSTEM mentioned in this chapter can be replaced with the new DBA user. If you use the newly created DBA User to execute the DBInstaller, then the validation file might display extra or missing privileges for the SYSTEM or the newly created DBA user.If you do not wish to create a new DBA user, you may enter SYSTEM when running the script.

To create the DBA user:

  1. From the command prompt, run the batch file:

    <Argus Release Media>\Database\Argus Safety\Utilities\Create_Dba_User\create_dba_user.bat

  2. Enter the following parameters:

    1. TNSName of the database

    2. SYSDBA username

    3. Password for SYSDBA account

    4. Name for the new DBA User account that will be created

    5. Password for the new account

  3. Follow the remaining steps to complete the script.

  4. You may also run the script:

    • For Windows—execute the script from <Argus Release Media>\Database\Argus Safety\Utilities\Create_Dba_User\create_dba_user.bat

    • For Linux—execute the script from <Argus Release Media>/Database/Argus Safety/Utilities/Create_Dba_User/create_dba_user