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.
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.
CA Strong Authentication(previously Webfort or AuthMinder) version-8.x,9.x
Oracle database (See platform support matrix for supported versions)
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.