Advanced Authentication table migration questions
search cancel

Advanced Authentication table migration questions

book

Article ID: 238061

calendar_today

Updated On:

Products

CA Strong Authentication CA Advanced Authentication CA Risk Authentication

Issue/Introduction

Customer required to migrate Advanced Authentication prod data from oracle 12c DB to 19c DB. It is observed that one table ARUDSUSERAUDITLOG has a very large size of data (27G). Can this table be skipped during the data migration? What is the impact?

Environment

Release : 9.1.x

Component : Strong Authentication

Resolution

ARUDSUSERAUDITLOG is used by the UDS ( User Data Service ) and Stores user operation-specific detailed audit logging information. This table grows very fast because for every transaction, User is fetched first and that is Audit logged in this table. This table is used to run the report User Activity Report but not used in Transaction related reports like the Analyze Transaction report for Risk Authentication or Authentication Activity report for Strong Authentication. If the User activity report is not required then the data from this table can be skipped for Migration.