Running CA Strong Authentication reports without tablespace privileges

Document ID : KB000010078
Last Modified Date : 14/02/2018
Show Technical Document Details
Introduction:

Is there any way to run CA Strong Authentication reports without requiring the ARREPORTS tablespace created and using the default tablespace.
Use case:
DBA may not agree to provide create tablespace privilege to the database user. Or the strict tablespace naming convention may not be as per organizational requirements.

Background:

Arcot common database scripts need the privilege to create Tablespace for generating reports. If this privilege is not available, the default tablespace can be used based on a configuration setting.

Environment:
CA Strong Authentication(previously Webfort or AuthMinder) version-8.xOracle database (See platform support matrix for supported versions)
Instructions:

A (hidden) configuration knob can be specified in arcot/report/config section of adminserver.ini file to use default tablespace.

If 'create tablespace' privilege is not available for reports, follow the steps below:
1. Make a section with following entries in adminserver.ini file (available at ARCOT_HOME/conf) at the end
[arcot/report/config]
UseDefaultTableSpace=true

2. Restart the application server.
If the knob is true, it will use the default tablespace.

Additional Information:
  • This option is available in Webfort 6.2.7 onwards.
  • ARREPORTS tablespace is used only for getting Reports into admin console based on the given conditions. In remaining cases we are not using tablespace. There should not be any performance impact when the default tablespace is used.
  • You need to remove the "CREATE TABLESPACE ARREPORTS" query from the common script if you do not want the tablespace to be created.
    File: arcot-db-config-for-common-8.1.sql
    --EXECUTE IMMEDIATE 'CREATE TABLESPACE ARREPORTS DATAFILE '''||filename||''' ................. ONLINE'; END;