The following table lists all database tables used by the Administration Console:
|
Table Name |
Description |
|---|---|
|
ARADMINAUDITTRAIL |
Stores administrator activity audit. |
|
ARADMINAUTHTOKEN |
Stores the tokens that Administration Console uses for pluggable authentication. Every time you log in to the Console by using password, a token is internally generated after password match and stored in this table. |
|
ARADMINBASICAUTHPWDHISTORY |
Stores the last n occurrences of password of all administrators in all organizations that use Basic Authentication (for administrators) to log in to the Administration Console. This information is stored to prevent password reuse. |
|
ARADMINBASICAUTHUSER |
Stores the basic authentication credentials of all administrators in all organizations that use Basic Authentication (for administrators) to log in to the Administration Console. |
|
ARADMINCONFIG |
Stores the Administration Console configurations. |
|
ARADMINCUSTOMROLE |
Stores the configurations for all custom-defined roles. |
|
ARADMINMANAGEROLE |
Stores the list of roles that a specified role can manage. |
|
ARADMINMAP |
Stores the information of the AuthMinder Server instance, which is entered as a key-value pair. |
|
ARADMINPAFCONFIG |
Stores the authentication configurations for all administrators in all organizations in the system. |
|
ARADMINPREDEFINEDROLE |
Stores the role information for all supported administrators. |
|
ARADMINPWDPOLICY |
Stores the details of password policies for all administrators in all organizations. |
|
ARADMINROLEPRIVILEGE |
Stores the mapping of all administrative actions (or tasks) supported by the Administration Console, the scope of each task, and which role can perform the task. |
|
ARADMINSCOPE |
Stores the list of organizations over which each administrator has control (scope). |
|
ARADMINSCOPEALL |
Stores the list of all administrators who have control (scope) over all the existing organizations in the system. |
|
ARADMINSUPPORTEDAUTHMECH |
Stores the information about all supported authentication mechanisms to log in to the Administration Console. |
|
ARADMINSUPPORTEDTIMEZONE |
Stores the list of all available time zones. Note: This is an internal table. |
|
ARADMINTURNEDOFFPRIVILEGE |
Stores the list of the privileges that are not available for the given custom role. |
|
ARADMINTXID |
Stores the information required to generate a unique ID for each transaction. |
|
ARADMINUITAB |
Stores the information about the tabs that are available and the order in which they are available in the Administration Console. |
|
ARADMINUITASK |
Stores the information about all the tasks that are available and the order in which they are available through the Administration Console. |
|
ARADMINUITASKATTRIBUTES |
Stores the details of the tasks that are displayed, when the first-level and the second-level tabs in the Administration Console are clicked. These tasks are referred to as landing pages. |
|
ARADMINUITASKCONTAINER |
Stores the information related to available task containers. A task container can either be a second-level tab ID or the task group in the Administration Console. |
|
ARADMINUSER |
Stores the detailed information (such as organization to which they belong, current status, time zone, locale, last login time) of all existing administrators. |
|
ARADMINUSER_ARCHIVE |
Stores the information related to all deleted users. |
|
ARADMINWIZARDTASK |
Stores the information about all the tasks that can be performed by using the Bootstrap Wizard. |
|
ARCMNBULKOPERATION |
Stores information related to all supported bulk operations that include uploading users and uploading user accounts. |
|
ARCMNBULKOPERATIONATTRIBUTE |
Stores attributes for all bulk operations in the ARCMNBULKOPERATION table. |
|
ARCMNBULKREQUEST |
Stores details (such as organization name, Request ID, status of the request, data uploaded, and operation) for each bulk-upload request. |
|
ARCMNBULKTASKPARAM |
Stores the name and the value of each attribute for each task supported in the system. |
|
ARCMNBULKUPLOADTASK |
Stores the status of each task for every bulk-upload request. |
|
ARCMNCACHEREFRESH |
Stores cache-related housekeeping information that indicates whether the Administration Console needs to be refreshed or not. |
|
ARCMNCONFIG |
Stores common Administration Console configuration information. Some of these include whether Bootstrap is complete, whether the cache refresh is automatic or manual, whether attribute encryption is enabled, and whether the bulk upload feature is enabled or not. |
|
ARCMNDBERRORCODES |
Stores vendor-specific database error codes and SQL state values that signify whether the database is down or non-responsive. This information is used by the system to decide if database should be failed over, in case a backup database is configured. |
|
ARCMNMAPDATATYPE |
Stores CA product-specific information that the Administration Console uses for rendering the Console pages. |
|
ARCMNKEY |
Stores the key configurations used while creating or updating organizations. |
|
ARPFCMNCACHEREFRESHEVENT |
Stores details of all cache refresh events for all instances in the system. |
|
ARPFCMNCACHEREFRESHSCOPE |
Stores information about all organizations that will be affected if a server cache refresh event occurs. |
|
ARPFCMNCACHEREFRESHSTATUS |
Stores the status of each cache refresh event for every instance for which it was triggered. |
|
ARPFCMNINSTANCE |
Stores detailed information for all AuthMinder Server instances configured in the system. This also includes the last time the instance was refreshed. |
|
ARPFCMNORGCONFIGDATA |
Stores configuration details for each organization. This includes global configurations that can be, typically, overridden at the organization-level. |
|
ARPFCMNORGCONFIGSTATE |
Stores the status of each assigned configuration from the ARPFCMNORGCONFIGDATA table. |
|
ARPFCMNPRIVILEGEMAPPING |
Stores the details of each privilege available through the Administration Console. |
|
ARREPORTTABLES |
Stores the information about the reports that are generated using Administration Console. |
|
ARSEQUENCETABLE |
Simulates sequences using stored procedures. Note: This table is used only by MS SQL Server. |
|
Copyright © 2013 CA.
All rights reserved.
|
|