Database Tables Used by CA Strong Auth
The following table lists the database tables that are used by the CA Strong Authentication Server:
aa813test
The following table lists the database tables that are used by the CA Strong Authentication Server:
Table Name
| Description
|
ARWFADMINAUDITLOG | Contains the audit log information for the CA Strong Authentication administration activities. |
ARWFARCOTEMV | Contains the CA Auth ID OTP-EMV credentials for the users. It contains an individual entry for each user. |
ARWFARCOTEMVHISTORY | Contains all the CA Auth ID OTP-EMV credentials that are in the reissue state. |
ARWFARCOTID | Contains the CA Auth ID credentials for the users. It contains an individual entry for each user. |
ARWFARCOTIDHISTORY | Contains all the CA Auth IDs that are in the reissue state. |
ARWFARCOTOTP | Contains the CA Auth ID OTP-OATH credentials for the users. It contains an individual entry for each user. |
ARWFARCOTOTPHISTORY | Contains all the CA Auth ID OTP-OATH credentials that are in the reissue state. |
ARWFAUTHAUDITLOG | Contains the audit log information for the authentication activities. |
ARWFAUTHTOKENS | Contains the authentication tokens that are generated after a successful authentication. One entry is made in this table for every successful authentication irrespective of the type of token requested. |
ARWFCONFIG | Contains the CA Strong Authentication configuration information. The information in this table contains version information and therefore has multiple entries per configuration. |
ARWFDBERRORCODES | Contains the database error codes that indicate the communication failure. |
ARWFDBQUERIES | Contains the list of database queries used by the CA Strong Authentication Server. |
ARWFDISPLAYNAMES | Contains names and values of different keys used in CA Strong Authentication. |
ARWFGENERICCRED | Contains the information about the miscellaneous credentials of the user. For example, the credentials supported by custom APIs. |
ARWFGENERICCREDHISTORY | Contains all the miscellaneous (for example, custom API supported) credentials that are in re-issue state. |
ARWFINSTANCES | Contains information about all the instances of CA Strong Authentication Servers that communicate with a specific database. |
ARWFISSUANCEAUDITLOG | Contains the audit log information for the credential issuance activities. |
ARWFMESSAGES | Contains the messages that are posted by the CA Strong Authentication Server. |
ARWFMODULEREGISTRY | Contains information about the internal modules of the CA Strong Authentication Server and about the plug-ins. |
ARWFOATH | Contains the OATH One-Time Password (OTP) credentials of the users. It contains an individual entry for each user. |
ARWFOATHHISTORY | Contains all the OATH OTP credentials that are in re-issue state. |
ARWFOATHTOKENREGISTRY | Contains the OATH token details such as, seed value, token ID, and token type. |
ARWFORGACTIVECONFIG | Contains configuration mapping of the currently active organization. The information in this table contains version information and therefore has multiple entries per configuration. |
ARWFORGCONFIG | Contains configuration mapping per organization. The information in this table contains version information and therefore has multiple entries per configuration. |
ARWFOTP | Contains the One-Time Password (OTP) credentials for the users. It contains an individual entry for each user. |
ARWFPASSWORD | Contains the user name-password credentials for the users. It contains an individual entry for each user. |
ARWFPASSWORDHISTORY | Contains all the user-name password credentials that are in re-issue state. |
ARWFPROTOCOLCONFIGURATION | Contains configuration of each listener port of the CA Strong Authentication Server. |
ARWFQNA | Contains the Question and Answer (QnA) credentials for the users. It contains an individual entry for each user. |
ARWFQNAHISTORY | Contains all the question and answer credentials that are in re-issue state. |
ARWFSEQUENCE | Contains information about sequences used for version configurations. |
ARWFSSLTRUSTSTORE | Contains the SSL root certificates that are trusted by the CA Strong Authentication Server. |
ARWFSVRMGMTAUDITLOG | Contains the audit log information for the server management activities. |
ARWFUNIQUEFIELDS | Enforces uniqueness of certain fields in the configuration. For example, a RADIUS client IP address cannot be used by two organizations. |
ARWFVERIFIEDCHALLENGES | Contains information about the challenges for which the CA Auth ID signature is successfully verified. An entry is made for successful CA Auth ID PKICA Auth IDCA Auth ID authentication, provided No Replay for challenge is turned on. It is turned off by default. |