If you have setup CA Strong Authentication without having ARREPORTS table space the report fetching will show errors. This article helps you to configure the table space post CA Strong Authentication installation.
Release : 9.1
During installation CA Strong Authentication, tables space for reports wasn't configured
If you missed creating the ARREPORTS tablespace during the installation, please follow the below process of creating ARREPORTS tablespace. It is used to run the reports.
Running Strong Authentication on Oracle requires two tablespaces:
If the database user running the script has sufficient permissions to create a tablespace, the database configuration script (db-config-for-common-9.1.02.sql) automatically creates the reports tablespace.
If the user does not have the required permissions, a DBA can manually create the reports tablespace.
Follow these steps in order to create a tablespace:
If you have previously added privileges to the user that the user does not require, you can use the following queries to identify and remove them:
Replace <dbusername> with the database user name (arcotuser in these procedures). Replace <privilege name> with the name of the privilege to remove.