CA Risk Authentication Windows Installation Guide › How to Deploy CA Risk Authentication on a Single System › Perform a Complete Installation › Run the Database Scripts

Run the Database Scripts

To create the database tables, run the required database scripts.

Follow these steps::

Important! Before you run the scripts, verify that you are logged in as the same database user that you created in the section, Configure Database Server.

1. Navigate to the following directory:

   <install_location>\Arcot Systems\dbscripts\
   

2. Navigate to one of the following subdirectories based on the database that you are using:
   • For Oracle: oracle\
   • For Microsoft SQL: mssql\
   • For MySQL: mysql\
3. Run the scripts in the following order:
   1. arcot-db-config-for-common-8.0.sql

      Important! If you have installed CA Strong Authentication, do not run arcot-db-config-for-common-8.0.sql because you have already run it while installing CA Strong Authentication.

   2. arcot-db-config-for-riskfort-8.0.sql
   3. (Optional) only if you must create the 3D Secure Channel) arcot-db-config-for-3dsecure-8.0.sql
   4. (Optional) only if you are using User Behavior Profiling, run the following command:

      arcot-db-config-for-userprofiling-2.0.sql
      

   Note: Running the script is one-time job. If you run the script every time, you may get errors like; table already exist, or insertions failed due to duplicate records.