Adding Oracle tables for reporting in Default Tablespace

Products

• CA Advanced Authentication - Strong Authentication (AuthMinder / WebFort)
• CA Strong Authentication
• CA Rapid App Security
• CA Risk Authentication
• CA Advanced Authentication

Issue/Introduction

We're trying to solve is that we've been given an oracle Tablespace for the AA database. But the reporting functionality wants a separate Tablespace for the reporting table. What configuration files house the settings to tell the system where the reporting database is at so that we can set up reporting?

 

Environment

Release : 9.1

Component : AuthMinder(Arcot WebFort)

Resolution

Product also had capability to use the Default Table space but that is not generally used by customers now a days, if you want to test here are the steps to do that -

Reports should work without requiring Tablespace creation privilege.
    Description:
 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.
 
    Resolution:
    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.
    
    Note: If the knob is true, it will use the default table space.