search cancel

Advanced Authentication table migration questions


Article ID: 238061


Updated On:


CA Strong Authentication CA Advanced Authentication CA Risk Authentication


I need to migrate AA prod data from oracle 12c DB to 19c DB. I noticed one table ARUDSUSERAUDITLOG has a very large size of data(27G). Can I omit this table during the data migration? what is the impact?


Release : 9.1

Component : Strong Authentication


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.